COUNTIF Subtotal Function?

J

jcpotwor

is there a countif for the subtotal function? I could like to perform a
countif on a list which I have autofiltered on. THANKS!
 
P

Peo Sjoblom

=SUMPRODUCT(--($C$2:$C$20>5),(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
 
D

Domenic

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal for text fields 0
countif in a subtotal function 1
Using <= in countifs statement 1
countif function 6
Combine Sumifs with Subtotal 0
Subtotal Countif 6
Countif to exclude blanks 3
Mac Countif function not working at all 0

Top