G Guest Jan 12, 2006 #1 is there a countif for the subtotal function? I could like to perform a countif on a list which I have autofiltered on. THANKS!
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 Jan 12, 2006 #2 =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
=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 Jan 12, 2006 #3 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!
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!
