Calculation Formula to Sum when Using Filter

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,

Who is Participating?
Use subtotal
Subtotal 102 will count the visible numbers in the range:
Typing =Subtotal( should give you a list of available total types
Bright01Author Commented:
Thank you!  It was simpler then we had orginally thought.  Very helpful.

Again, much thanks!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.