COUNTIF of an array not working

[icyrius]

I just installed Excel 2016 and thought this would be a straight forward calculation, but I cannot get it to work.

I want to count how many results from the following array are non-zero,

{=IF((E13:E32)*(W13:W32)>0,(W13:W32))*1}

When I use COUNTIF it would give me a prompt to use (') in the formula which does not make sense. Here is the formula I am entering,

{=COUNTIF(IF((E13:E32)*(W13:W32)>0,(W13:W32))*1,">0")}

Any help will be greatly appreciated.

Thanks.

[jason.b75]

Try (non-array formula)

=SUMPRODUCT(--((E13:E32*W13:W32)>0))

or

=COUNTIFS(E13:E32,">0",W13:W32,">0")

Arrays are not valid in the first part of countif, you can use ranges, or functions that return ranges (i.e. index, offset, indirect).

[icyrius]

Excellent! It works. Thanks.

[José Augusto]

Try these
=SUMPRODUCT(--(E13:E22*W13:W22<>0))

[jason.b75]

You're welcome, thanks for the feedback!

In case you missed it, I've edited my post to include an alternative method.