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

Setting column width in a table with a macro is not working 0
Copy corresponding cell in Column B if cell in A contains certain text? 1
in excel how to pull only used information to another sheet 1
Count Column B if Column A is within a multiple specificed ranges 2
Count column b if column a equal cell value 7
How do I filter data by more than one column in excel 0
Getting a formula to reflect added columns 10
I need to group by one column to show all their details 0

Top