Subtotal with IF formula

[ryan7]

My formula is

=SUBTOTAL(9,T4:T3551)

I want to add another criteria so that it only calculates cells with a value greater than Zero,

Can someone please help?

Thanks

 

[maabadi]

Function number 109 only sum visible rows, if you want sum total rows with hidden rows, Use number 9.

 

[ryan7]

Number 9 does not work either.

 

[Fluff]

How about

=SUMIF(T:T,">0")

 

[ryan7]

How about

=SUMIF(T:T,">0")

So Simple. Worked perfectly.

 

[Fluff]

You're welcome & thanks for the feedback.