Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF Subtotal Function?
is there a countif for the subtotal function? I could like to perform a
countif on a list which I have autofiltered on. THANKS! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF Subtotal Function?
=SUMPRODUCT(--($C$2:$C$205),(SUBTOTAL(3,OFFSET($C$2,ROW($C$2:$C $20)-MIN(ROW
($C$2:$C$20)),,)))) will count how many cells in C2:C20 are greater than 5 in a filtered list adapt to fit -- Regards, Peo Sjoblom "jcpotwor" wrote in message ... is there a countif for the subtotal function? I could like to perform a countif on a list which I have autofiltered on. THANKS! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF Subtotal Function?
Try...
=SUMPRODUCT(SUBTOTAL(3,OFFSET(Range,ROW(Range)-MIN(ROW(Range)),0,1)),--(R ange="Criteria")) If your criteria is a numerical value, remove the quotes. Hope this helps! In article , "jcpotwor" wrote: is there a countif for the subtotal function? I could like to perform a countif on a list which I have autofiltered on. THANKS! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Excel countif function | Excel Worksheet Functions | |||
countif function | Excel Worksheet Functions | |||
The countif function in Excel 2002. | Excel Worksheet Functions | |||
hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions |