=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.
Bookmarks