Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif function
Hi
I have the following formula in one of the cell =COUNT(IF((TRIM($C$4:$C$96)="P")*ISBLANK($M$4:$M$9 6),$A$4:$A$96)) because I am calculating number of rows where column 'c' has value 'p' and colimn 'm' is blank. But I have autofilter command using VBA code and I want the rows to be counted based on the output of the filter results. Example column 'N' has a filter where the selection is 'A' & 'B'. I want the my formula COUNT(IF((TRIM($C$4:$C$96)="P")*ISBLANK($M$4:$M$96 ),$A$4:$A$96)) to count only filtered rows if the filter is used |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif function
Please refrain from multiposting, I already gave you an answer yesterday
that let you do this -- Regards, Peo Sjoblom |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif function
Use the SUBTOTAL() function with 2 as the 1st argument and it will only
count the visible rows with numbers. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "ub" wrote in message ... Hi I have the following formula in one of the cell =COUNT(IF((TRIM($C$4:$C$96)="P")*ISBLANK($M$4:$M$9 6),$A$4:$A$96)) because I am calculating number of rows where column 'c' has value 'p' and colimn 'm' is blank. But I have autofilter command using VBA code and I want the rows to be counted based on the output of the filter results. Example column 'N' has a filter where the selection is 'A' & 'B'. I want the my formula COUNT(IF((TRIM($C$4:$C$96)="P")*ISBLANK($M$4:$M$96 ),$A$4:$A$96)) to count only filtered rows if the filter is used |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif function | Excel Discussion (Misc queries) | |||
please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
Countif/And Function | Excel Discussion (Misc queries) |