using sumproduct or sumif

[alienscript]

Hi !

Is there a way to use sumproduct or sumif formula to count the number of cells that has the value in column B greater than or equal to the corresponding value in column A ?

In the sample workbook(Excel 2003), the answer should be 10. Appreciate any help that is given. Thanks!

[tkaplan]

=SUMPRODUCT(--(B1:B20>=A1:A20))

[MaximS]

try that:

{=SUM(IF(B1:B20>=A1:A20,1,0))}

with ctrl+shift+enter

[alienscript]

Thanks for that, but both suggestions give the summation. What I want is to count the number of cells when the condition is true.

Anyone can help me on this?

Thanks.

[Zack Barresse]

Both formulas actually give you the count, NOT the sum. Is that not what you're looking for?

[alienscript]

I'm terribly sorry coz I thought sumproduct and sum are only summation functions... It works perfectly! I can't say how much I'm grateful for the help... Thanks so much :)

[Zack Barresse]

Check out the SUMPRODUCT forum. Good stuff. :)