ExcelBanter - COUNTIF

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - COUNTIF - Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/159577-countif-excel-2007-a.html)

Railrd

COUNTIF - Excel 2007

Want to count how many times Column A is greater than Column B and looking
for the formula.
ex
A B

4 2
3 6
1 0

Want result of 2

Peo Sjoblom

COUNTIF - Excel 2007

=SUMPRODUCT(--(A1:A100B1:B100))

--

Regards,

Peo Sjoblom

"Railrd" wrote in message
...
Want to count how many times Column A is greater than Column B and looking
for the formula.
ex
A B

4 2
3 6
1 0

Want result of 2

Railrd

COUNTIF - Excel 2007

Thank You VERY Much

"Peo Sjoblom" wrote:

=SUMPRODUCT(--(A1:A100B1:B100))

--

Regards,

Peo Sjoblom

"Railrd" wrote in message
...
Want to count how many times Column A is greater than Column B and looking
for the formula.
ex
A B

4 2
3 6
1 0

Want result of 2

All times are GMT +1. The time now is 02:20 AM.