Summing Worksheets in Same Workbook

[zapszipszops]

Hi there,

I have a workbook that contains a worksheet for each day of the month. Each worksheet has a list of employee names and how many products they have sold. At the bottom of the list, I have a total. I am trying to sum all the totals from each worksheet to get the monthly sales total. I tried using Sum(top:bottom), but the only problem is the cell with the total is never in the same cell in each worksheet. Any ideas?

Thank you very much,
Julie

[Carim]

Hello Julie,

Among many possibilities, Insert Name Define your different ranges ...
Rng1, Rng2, Rng3 ,etc ...

then, you can have
MonTotal = Rng1+Rng2+Rng3+....

HTH
Carim

[Dav]

Your simple solution is to put the total in a different cell say a row at the top of each worksheet, it could even say sum(B:b) for example and reference the whole column. you could hide the row with the formula in it would not have to be visible, but then you could adopt the approach you orriginally suggested. If you have a sum at the bottom of your data in say column B you could still use this approach, but divide the total by 2.

using something like Sum(sheet1!:sheet2!b1)

Regards

Dav

[Mark@Work]

My first thought is that everything would be much easier if the totals cell was aways in the same place on each sheet.

Would it not be possible to rearrange your sheets to have the totals on (for example) row 1. Thus :

Totals.........45.........67........3
.............Widgits...thingys...whatsits
Tom..........5............30........2
****..........15...........17........0
Harry........25...........20........1

Or am I missing the point?

Mark

[Dav]

I agree with the previous post. We are both proposing the same solution. The row does not even need to be visible in the sheets, so the sheet could look just the same as it does now.


Regards

Dav