Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum a lot of box in different pages
i have an excel workbook that i write the actions in my work (buy or
sell something in day). End of a month i need to sum some of these boxes. How can i do this?? there are 110 pages like "05-06-05G" *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum a lot of box in different pages
for the same cell on every page
=Sum(05-06-05A:07-08-09Z!B9) where the names represent the names of the first and last sheets in the tab order that you want to sum the cells in. This is called a 3D reference. If just a few cells you can refer to the sheet names as part of the address =05-06-05A!A1+05-06-05B!H1+05-06-04A1 This assumes that by BOX you mean CELL. -- Regards, Tom Ogilvy "seckin bilgic" wrote in message ... i have an excel workbook that i write the actions in my work (buy or sell something in day). End of a month i need to sum some of these boxes. How can i do this?? there are 110 pages like "05-06-05G" *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of pages in worksheet doesn't match Print Preview pages | Excel Discussion (Misc queries) | |||
How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages.. | Setting up and Configuration of Excel | |||
Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages... | Excel Worksheet Functions | |||
How do I delete pages from an Excell template of mutiple pages | Excel Discussion (Misc queries) |