Solved

# Calculation Formula to Sum when Using Filter

Posted on 2012-09-20
Medium Priority
516 Views
EE Professionals;

Can someone give me a formula or function that "counts" the records (Blanks or Non-Blanks) in a FILTERED Column?  In other words as I filter a table (A1:D100) and it changes the number of records (A Subset), how do I count the new list?

Thank you,

B.
0
Question by:Bright01

LVL 24

Accepted Solution

Steve earned 2000 total points
ID: 38417438
Use subtotal
Subtotal 102 will count the visible numbers in the range:
=SUBTOTAL(102,C6:C15)
Typing =Subtotal( should give you a list of available total types
0

Author Closing Comment

ID: 38417537
Thank you!  It was simpler then we had orginally thought.  Very helpful.

Again, much thanks!

B.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Six Sigma Control Plans
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as formâ€¦
###### Suggested Courses
Course of the Month14 days, 18 hours left to enroll