I had found out how to add up the values of a page and have them total
on a different page - but I forgot .
I havge 72 different categories with 8 sub categories related (people
to say vacation days), each once in a tab with 12 tabs. How to I add
each subcategory onto a total page but still have it related to the
same person on the same total page?


--
DarklyCute1
------------------------------------------------------------------------
DarklyCute1's Profile: http://www.excelforum.com/member.php...o&userid=35949
View this thread: http://www.excelforum.com/showthread...hreadid=560657

Hi

Do you mean
=SUM(Sheet1:Sheet12!B2)
which would add cell B2 from each of the sheets between sheet1 and
sheet12 inclusive.
Or maybe
=SUM(Jan:Dec!B2) if you have names your tabs as months.
I like to create 2 extra dummy sheets for this task which I name as
First and Last and drag these to a position which encompasses the range
of sheets I wish to sum.
Then on my Summary Sheet (which is outside of the "sandwich created by
First and Last) the formula is then
=SUM(First:Last!B2)

Dragging Last to different positions, then allows the same formula to
sum different numbers of months (if required).

--
Regards

Roger Govier


"DarklyCute1"
wrote in message
...

I had found out how to add up the values of a page and have them total
on a different page - but I forgot .
I havge 72 different categories with 8 sub categories related (people
to say vacation days), each once in a tab with 12 tabs. How to I add
each subcategory onto a total page but still have it related to the
same person on the same total page?


--
DarklyCute1
------------------------------------------------------------------------
DarklyCute1's Profile:
http://www.excelforum.com/member.php...o&userid=35949
View this thread:
http://www.excelforum.com/showthread...hreadid=560657