How do I count nonblanks in column A when I filter by column B

R

RP3

I am using COUNTA in column A to count nonblanks. However, when I Autofilter
the sheet by Column B, the COUNTA in column A is unaffected. Example:

A B
Tim Kitchen
Bob Kitchen
Kitchen
John Floor
Floor
Carrie Floor

COUNTA shows "4" for column A.

When I filter the sheet by column B for "Kitchen":

A B
Tim Kitchen
Bob Kitchen
Kitchen

COUNTA still shows "4" for column A.

Is there a way to count nonblanks in column A when I filter by column B?
 
R

RagDyeR

Instead of:

=COUNTA(A:A)

USE:

=SUBTOTAL(3,A:A)

On filtered lists.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I am using COUNTA in column A to count nonblanks. However, when I
Autofilter
the sheet by Column B, the COUNTA in column A is unaffected. Example:

A B
Tim Kitchen
Bob Kitchen
Kitchen
John Floor
Floor
Carrie Floor

COUNTA shows "4" for column A.

When I filter the sheet by column B for "Kitchen":

A B
Tim Kitchen
Bob Kitchen
Kitchen

COUNTA still shows "4" for column A.

Is there a way to count nonblanks in column A when I filter by column B?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Imported Data creates blank cells that aren't really blank 14
Req help matching values across columns in Excel 1
in excel how to pull only used information to another sheet 1
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Count column b if column a equal cell value 7
How do I count a range of dates in a column? 6
COUNTA Function 4
Filter nonblanks from sheet into single column 1

Top