Need Some Help Here

[lsmft]

I have a worksheet detailing weekly income since year 2001.
Cell A1, is the first week's income for 2006.
Cell B1, is the first week's income for 2005, etc.
This will go on down the sheet to row 52.
What I'd like is a formula that I can use in say Cell "A 54", of colum
A to tell me how many weeks had an income greater than the same week'
incomes represented in column B. Same for Column B, compared to Colum
C, etc. I have tried using the countif function but it is coming bac
as "0" even with half of the weeks shown Column A, are greater than i
column B

 

[Bob Phillips]

=SUMPRODUCT(--(A1:A52>B2:B52))

etc.

 

[lsmft]

Thanks Bob,
Works just fine.