Count

[Ylopez_21]

I am trying to count how how many times the value in column B is greater than column A. Any help appreciated

ColumnA	Column B
126.83	0
1805.89	0
1805.89	0
542.29	538.04
1711.52	1712.24
2546.59	0
686.65	706.38
683.52	696.06
836.33	0

<tbody>
</tbody><colgroup><col><col></colgroup>

 

[Weazel]

maybe ...

=SUMPRODUCT(--(B2:B10>A2:A10))

 

[Rick Rothstein]

I am trying to count how how many times the value in column B is greater than column A. Any help appreciated

ColumnA	Column B
126.83
1805.89
1805.89
542.29	538.04
1711.52	1712.24
2546.59
686.65	706.38
683.52	696.06
836.33

<TBODY>
</TBODY>

If I understand your question correctly, put this formula in A1 and copy it down to A9 (for the sample data you posted)...

=COUNTIF(A$1:A$9,"<"&B1)