Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Countif with autofillter
I am trying to use auto filter with the "countif" function?
This Formula gives me a percent for the hole document: =(COUNTIF(AK3:AK5000,9)+COUNTIF(AK3:AK5000,10))/COUNT(AK3:AK5000) I want to be able to auto filter the data and have the percent from the above function change to reflect only the visible info. Basically trying to count only the number 9 and the number 10 for the visible info divided by the total number of results within the same column. ANYHELP???? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Countif with autofillter
I think you need to take a look at the subtotal function.
Look at this too: http://www.j-walk.com/ss/excel/usertips/tip023.htm Something like this =SUBTOTAL(2,A6:A3006) =SUBTOTAL(102,A6:A3006) I think it depends on which version of Excel you are using. Anyway, give it a shot and see what happens... Regards, Ryan--- -- RyGuy "John" wrote: I am trying to use auto filter with the "countif" function? This Formula gives me a percent for the hole document: =(COUNTIF(AK3:AK5000,9)+COUNTIF(AK3:AK5000,10))/COUNT(AK3:AK5000) I want to be able to auto filter the data and have the percent from the above function change to reflect only the visible info. Basically trying to count only the number 9 and the number 10 for the visible info divided by the total number of results within the same column. ANYHELP???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |