Change formula to count if VALUE

[Utradeshow]

Hi Guy's,

I have this formula that works for adding numbers. I need to to count how many cells in column H has a value.

=SUMPRODUCT(--(INDIRECT(B$1&"!C2:C20000")=$A13),INDIRECT(B$1&"!H2:H20000"))

Is this possible?

 

[Kaper]

try

=SUMPRODUCT((INDIRECT(B$1&"!C2:C20000")=$A13)*(INDIRECT(B$1&"!H2:H20000")<>0))

 

[Utradeshow]

Thank you! Works perfectly!

 

[Kaper]

Glad to hear that, and thanks for marking my post as a solution