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



--
Chris

Chris,

Try

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

Mike

"Chris S." wrote:

> 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
>
>
>
> --
> Chris

Sorry tiy said greater than 1

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

Mike

"Chris S." wrote:

> 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
>
>
>
> --
> Chris