Count values in different columns

[Chris S.]

I want a to calculate the number of values in row A for the corresponding
value in row C that is great than 1.
For example in row 4 in column A I have 0.0099 but 0 in column C in row 4,
therefore the result would be 0. For the whole column A the correct result
should be 3.
A B C
0.0134 10711
0.0160 8071
0.0170 16410
0.0099 0
0.0103 0
0.0085 8827
0.0135 0
0.0050 0.0164 0
0.0093 0
0.0105 16313

 

[Mike H]

Chris,

Try

=SUMPRODUCT((A1:A20>0)*(C1:C20>0))

Mike

 

[Mike H]

Sorry tiy said greater than 1

=SUMPRODUCT((A1:A20>0)*(C1:C20>1))

Mike