hello
i count D5:D54 filter data but i want count only when value is greater then 0(zero)

SUBTOTAL(2,D5:D54)
I Mean
d5 = 0 don't count
d6 = 0 don't count
d7 = 0 don't count

if d5:d54 has value greater then 0 then count...

thanx