Formulas do not work??

[ff_emt1]

Just upgraded to Excel 2010. I have the following formulas calculating weekly data:

Week 1 =SUM('Current Week'!GZ2:GZ32)
Week 2 =SUM('Current Week'!GZ33:GZ75)
Week 3 =SUM('Current Week'!GZ76:GZ109)
Week 4 =SUM('Current Week'!GZ110:GZ136)
Week 5 =SUM('Current Week'!GZ137:GZ156)
Week 6 =SUM('Current Week'!GZ157:GZ193)
Week 7 =SUM('Current Week'!GZ194:GZ233)
Week 8 =SUM('Current Week'!GZ234:GZ251)
Week 9 =SUM('Current Week'!GZ252:GZ293)
Week 10 =SUM('Current Week'!GZ294:GZ321)
Week 11 =SUM('Current Week'!GZ322:GZ351)
Week 12 =SUM('Current Week'!GZ352:GZ381)
Week 13 =SUM('Current Week'!GZ382:GZ409)
Week 14 =SUM('Current Week'!GZ410:GZ426)
Week 15 =SUM('Current Week'!GZ427:GZ466)
Week 16 =SUM('Current Week'!GZ467:GZ500)
Week 17 =SUM('Current Week'!GZ501:GZ534)
Week 18 =SUM('Current Week'!GZ535:GZ559)
Week 19 =SUM('Current Week'!GZ560:GZ578)
Week 20 =SUM('Current Week'!GZ579:GZ605)
Week 21 =SUM('Current Week'!GZ606:GZ614)
Week 22 =SUM('Current Week'!GZ615:GZ629)
Week 23 =SUM('Current Week'!GZ630:GZ653)
Week 24 =SUM('Current Week'!GZ654:GZ676)
Week 25 =SUM('Current Week'!GZ677:GZ696)
Week 26 =SUM('Current Week'!GZ697:GZ705)
Week 27 =SUM('Current Week'!GZ706:GZ719)
Week 28 =SUM('Current Week'!GX720:GX725)
Week 29 =SUM('Current Week'!GZ726:GZ729)

When I sum the column I do not get the same answer as =SUM('Current Week'!GZ2:GZ729). Sum of the weekly formulas is 357588.28 and the single formulas is 360650.52. Any idea what I am doing wrong?

 

[Jonmo1]

Your Week 28 formula is suming column GX while all others are summing GZ

 

[ff_emt1]

Thanks a lot. Now I feel stupid. I probably went over those formulas 10 times and missed that. I was looking at the cell references. Thanks again.

 

[Jonmo1]

Glad to help, and no worries. sometimes a fresh set of eyes is all that is needed.

BTW,

Those weekly sums might be easier if you have some kind of key column to indicate which week the row is associated with.
Like if on the Current Week Sheet, you put a number in Column A (or whatever column you like) to represent the week number.
Then instead of hard coding all those different row numbers in each different weekly sum formula, you can use SUMIF
=SUMIF('Current Week'!A$2:A$729,1,'Current Week'!GZ$2:GZ$729)
=SUMIF('Current Week'!A$2:A$729,2,'Current Week'!GZ$2:GZ$729)
=SUMIF('Current Week'!A$2:A$729,3,'Current Week'!GZ$2:GZ$729)
etc.