Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another data across multiple worksheets question (ugh..)
Aright, here's my problem that I've already been working an hour on:
End Goal = being able to see current total of all sales on every worksheet in a single cell. I have 4 worksheets in my workbook - Jan-Mar'07, Apr-June'07, July-Sept.'07, Oct.-Nov'07 For example, in the Jan-Mar'07 worksheet, I have a January column, Feb. column, and March column. Each month has a tally at the bottom that adds in everyday the new numbers. Then, to the right, I have a separate cell that adds all the months together =SUM(B36+E36+H36) , this is in cell K35. Now, when I click on the second worksheet Apr-June'07 everything is the exact same, with different numbers each day and months of course. K35 is the total of 3 months in this worksheet as well. And so on for the following two worksheets. So, in a nutshell, I guess I'm asking how do I take the values of K35 on every sheet and put it in a new cell that gives me a running tally for the entire year (so I don't have to keep adding up the K35 cells every darn time I want to know what the yearly total is - most annoying at the end of the year when all 4 sheets are full) I thought it was =SUM(Sheet1:Sheet2:Sheet3:Sheet4!K35) but I keep getting an 'error in formula' message. Please help.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
How to summarise data in the same place in multiple worksheets? | Excel Discussion (Misc queries) | |||
sort data on multiple worksheets | Excel Discussion (Misc queries) | |||
How to extract data from multiple worksheets.. | Excel Discussion (Misc queries) | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions |