Subtotal

K

KC

Hi,

I use =SUBTOTAL(2,F3:F368) to count a column of $ values.

How can I ammend the SUBTOTAL formula to only count values greater
than 1.00?

Tks, Kay Seeton
 
A

Aladin Akyurek

=SUMPRODUCT(SUBTOTAL(3,OFFSET(F3:F368,ROW(F3:F368)-MIN(ROW(F3:F368)),,1)),--(F3:F368>1))
 
Top