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 column
A to tell me how many weeks had an income greater than the same week's
incomes represented in column B. Same for Column B, compared to Column
C, etc. I have tried using the countif function but it is coming back
as "0" even with half of the weeks shown Column A, are greater than in
column B.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=537484

=SUMPRODUCT(--(A1:A52B2:B52))

etc.

lsmft wrote:
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 column
A to tell me how many weeks had an income greater than the same week's
incomes represented in column B. Same for Column B, compared to Column
C, etc. I have tried using the countif function but it is coming back
as "0" even with half of the weeks shown Column A, are greater than in
column B.

Thanks Bob,
Works just fine.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=537484