Count filterd value if greater than 0(zero)

[HaroonSid]

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

Please Login or Register  to view this content.

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

[adyteo]

Please Login or Register  to view this content.

[HaroonSid]

hello adyteo

i want to user greater then 0 in subtotal formula

Please Login or Register  to view this content.

[adyteo]

why do you want to use SUBTOTAL function instead of COUNTIF?

[HaroonSid]

i want to count filter data

[adyteo]

can you add a helper column where you mark the visible column and then use COUNTIF?

if you can add the helper column, then you can put in there (column F, for example):

Please Login or Register  to view this content.

and then

Please Login or Register  to view this content.

[HaroonSid]

thanx adyteo

working well