Embed a countif function in subtotal function?

S

Stuck at work

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
 
D

Domenic

Try...

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

Hope this helps!
 
Top