Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count nonblanks in column A when I filter by column B
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count nonblanks in column A when I filter by column B
Instead of:
COUNTA( use this: SUBTOTAL(3, Hope this helps. Pete On Jan 13, 4:23*pm, RP3 wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count nonblanks in column A when I filter by column B
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count nonblanks in column A when I filter by column B
Excellent!! Thanks for your help!
"Pete_UK" wrote: Instead of: COUNTA( use this: SUBTOTAL(3, Hope this helps. Pete On Jan 13, 4:23 pm, RP3 wrote: 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count nonblanks in column A when I filter by column B
You're welcome - thanks for feeding back.
Pete On Jan 13, 5:01*pm, RP3 wrote: Excellent!! *Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count cells w/values in column if the data in column a matches cri | Excel Worksheet Functions | |||
Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
Count entries in one column based on values in another column | Excel Worksheet Functions | |||
Filter for blanks - nonblanks problem | Excel Discussion (Misc queries) | |||
SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions |