ExcelBanter - COUNTIF Subtotal Function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - COUNTIF Subtotal Function? (https://www.excelbanter.com/excel-discussion-misc-queries/64731-countif-subtotal-function.html)

jcpotwor

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!

Peo Sjoblom

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!

Domenic

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!

All times are GMT +1. The time now is 03:43 PM.