| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing 3 worksheets on a total sheet
Have tried sheet1+sheet2+sheet3, sometimes my formulas get off. Here's what
i have: prop # Total billed $ actual billed $ 147 $166 $90 I have 24 properties on 3 spreadsheets. i need to sum all 3 property 147 total billed (actual also) on my Total sheet. please help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summing 3 worksheets on a total sheet
=SUM(Sheet1:Sheet3!A1)
-- David Biddulph "jliv" wrote in message ... Have tried sheet1+sheet2+sheet3, sometimes my formulas get off. Here's what i have: prop # Total billed $ actual billed $ 147 $166 $90 I have 24 properties on 3 spreadsheets. i need to sum all 3 property 147 total billed (actual also) on my Total sheet. please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summing a row, remove lowest values from the total | Excel Discussion (Misc queries) | |||
| Summing related cell values and returning total to summary | Excel Discussion (Misc queries) | |||
| Problem with summing formula updating Total... | Excel Discussion (Misc queries) | |||
| Need help summing the total of two columns with their products | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Linear Mode
