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

[TABLE="width: 180"]
<tbody>[TR]
[TD="align: right"]ColumnA [/TD]
[TD] Column B[/TD]
[/TR]
[TR]
[TD="align: right"]126.83[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1805.89[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1805.89[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]542.29[/TD]
[TD="align: right"]538.04[/TD]
[/TR]
[TR]
[TD="align: right"]1711.52[/TD]
[TD="align: right"]1712.24[/TD]
[/TR]
[TR]
[TD="align: right"]2546.59[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]686.65[/TD]
[TD="align: right"]706.38[/TD]
[/TR]
[TR]
[TD="align: right"]683.52[/TD]
[TD="align: right"]696.06[/TD]
[/TR]
[TR]
[TD="align: right"]836.33[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

 

[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

[TABLE="width: 180"]
<TBODY>[TR]
[TD="align: right"]ColumnA
[/TD]
[TD]Column B
[/TD]
[/TR]
[TR]
[TD="align: right"]126.83
[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]1805.89
[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]1805.89
[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]542.29
[/TD]
[TD="align: right"]538.04
[/TD]
[/TR]
[TR]
[TD="align: right"]1711.52
[/TD]
[TD="align: right"]1712.24
[/TD]
[/TR]
[TR]
[TD="align: right"]2546.59
[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]686.65
[/TD]
[TD="align: right"]706.38
[/TD]
[/TR]
[TR]
[TD="align: right"]683.52
[/TD]
[TD="align: right"]696.06
[/TD]
[/TR]
[TR]
[TD="align: right"]836.33
[/TD]
[TD="align: right"][/TD]
[/TR]
</TBODY>[/TABLE]

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)