Thanks Daddylonglegs, That doesn't work as I'm adding sections of the totals.
IN Monthly sheet, I'm only adding portions in A13, B13, C13, D13 and E 13 with the total combined in F13.
I modifed your formula to this:
=SUMIF(Yearly!$E:$E,"<="&$G$11,Yearly!$F3:$X4740)
=SUMIF(Yearly!$E:$E,"<="&$G$11,Yearly!$Y3:$AO4740)
=SUMIF(Yearly!$E:$E,"<="&$G$11,Yearly!$AP3:$AY4740)
=SUMIF(Yearly!$E:$E,"<="&$G$11,Yearly!$AZ3:$BK4740)
=SUMIF(Yearly!$E:$E,"<="&$G$11,Yearly!$BL3:$BQ4740)
And it doesn't add all cells in the ranges specified.
Does it have something to do with the empty cells with no dates in Column E of the yearly sheet?
Bookmarks