# Formulas do not work??

#### ff_emt1

##### Board Regular
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?

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Your Week 28 formula is suming column GX while all others are summing GZ

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.

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.

Replies
3
Views
128
Replies
1
Views
130
Replies
7
Views
285
Replies
1
Views
105
Replies
3
Views
122

1,196,357
Messages
6,014,774
Members
441,847
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back