Embed a countif function in subtotal function?
 

How do I set up a formula to count only from the VISIBLE rows (Filter is on)
the cells that fulfill another condition? Ie Countif it's equal to 1, but
only from the rows that are visible?

Thank you very much,

Dan

Embed a countif function in subtotal function?
 

Try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(A2:A10,ROW(A2:A10)-ROW(A2),0,1)),--(A2:A10=
1))

Hope this helps!

In article ,
"Stuck at work" <Stuck at wrote:

How do I set up a formula to count only from the VISIBLE rows (Filter is on)
the cells that fulfill another condition? Ie Countif it's equal to 1, but
only from the rows that are visible?

Thank you very much,

Dan