SUBTOTAL with condition

Hello

I'm looking for a formula that would work with SUBTOTAL function (109) and add values which are >0.

See example.

Many thanks
Marcin

Try this:

=SUMPRODUCT(SUBTOTAL(109,OFFSET(C5:C30,ROW(C5:C30)-MIN(ROW(C5:C30)),0,1)),(C5:C30>0)+0)

Thanks! It works for me!