Count values in different columns
 

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

Count values in different columns
 

Chris,

Try

=SUMPRODUCT((A1:A200)*(C1:C200))

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

Count values in different columns
 

Sorry tiy said greater than 1

=SUMPRODUCT((A1:A200)*(C1:C201))

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