How do I count nonblanks in column A when I filter by column B
Excellent!! Thanks for your help!
"RagDyeR" wrote:
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!
================================================== ===
"RP3" wrote in message
...
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?
|