This one always gets me and I can never remember how to do it, so I had a
friend write up this article, Dond:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"dond" wrote in message
...

=SUMIF(Rewards!$AH$3:$BI$3,Targets!O30, Rewards!$AH$20:$BI$20)
=SUMIF(Rewards!$AH$3:$BI$3,Targets!O30, Rewards!$AH$20:$BI$20)
In the above equation I am trying to get a total using sumif.
The rewards cells row 3 refer to a range of automatically generated
consecutive date cells.

The target cell is a manually entered date

The reward cells in row 20 are automatically generated numbers.

What I am trying to do is have the calculation check for the date in
Targets and then only sum the numbers that are entered on dates equal
or after that entered in targets
I also tried
=SUMIF(Rewards!$AH$3:$BI$3, "Targets!O30:<O31",
Rewards!$AH$20:$BI$20)

in the hope of getting it to sum between two given dates.
Any clues out there? I'm going around in circles here.


--
dond
------------------------------------------------------------------------
dond's Profile:
http://www.excelforum.com/member.php...o&userid=25477
View this thread: http://www.excelforum.com/showthread...hreadid=483373