Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling info from multiple worksheet tabs?
I have a summary page that pulls from multiple worksheet tabs, call them 1, 2
and 3. On the summary page I want to sum specific cells on a tab, say cell a1,a2,a3. Can I on the summary sheet make a formula that will sum those cells, but be flexible enough to recognize what tab I want summed by referencing another cell on the summary page? In other words if I put 1 in cell a1 on the summary sheet it will know to go to worksheet 1 and sum the right cells, and if I put 2 in A1 it will know to sum those cells on worksheet 2? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling info from multiple worksheet tabs?
Try this in your summary sheet:
=IF(OR(A1<1,A13),"",SUM(INDIRECT("Sheet"&INT(A1)& "!A1:A3"))) where A1 on the summary sheet is used to hold 1, 2 or 3, and depending on this value the sum will be returned from cells on Sheet1, Sheet2 or Sheet3. If A1 is out of range then you will have a blank result. Hope this helps. Pete Paul wrote: I have a summary page that pulls from multiple worksheet tabs, call them 1, 2 and 3. On the summary page I want to sum specific cells on a tab, say cell a1,a2,a3. Can I on the summary sheet make a formula that will sum those cells, but be flexible enough to recognize what tab I want summed by referencing another cell on the summary page? In other words if I put 1 in cell a1 on the summary sheet it will know to go to worksheet 1 and sum the right cells, and if I put 2 in A1 it will know to sum those cells on worksheet 2? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow multiple rows of worksheet tabs for complex spreadsheets | Excel Discussion (Misc queries) | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
update multiple worksheet in single book | Excel Worksheet Functions | |||
Hierarchical Worksheet Tabs??? New Excel feature? | Excel Discussion (Misc queries) | |||
Delete ENTIRE row after updating info in worksheet. | Excel Worksheet Functions |