| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total amounts acquired through formula's referencing other sheet
When I try to use =SUM ( : ), to get a total for amounts which were
calculated using formulas referencing amounts on another sheet, nothing happens (I do not get a total). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
total amounts acquired through formula's referencing other sheet
Show us the actual formula you are using.
=SUM(Sheet2!A1:A10) works for me. Gord Dibben MS Excel MVP On Fri, 4 Jan 2008 14:41:00 -0800, PVUMIGQS wrote: When I try to use =SUM ( : ), to get a total for amounts which were calculated using formulas referencing amounts on another sheet, nothing happens (I do not get a total). |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
total amounts acquired through formula's referencing other she
Gord, thanks for the help. Your formula worked.
Rhona "Gord Dibben" wrote: Show us the actual formula you are using. =SUM(Sheet2!A1:A10) works for me. Gord Dibben MS Excel MVP On Fri, 4 Jan 2008 14:41:00 -0800, PVUMIGQS wrote: When I try to use =SUM ( : ), to get a total for amounts which were calculated using formulas referencing amounts on another sheet, nothing happens (I do not get a total). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total the highest 5 of 8 amounts. | New Users to Excel | |||
| Want to total the amounts between certain dates | Excel Discussion (Misc queries) | |||
| how to total amounts in one colum | Excel Worksheet Functions | |||
| Is it possible to get a sub-total of amounts when... | Excel Discussion (Misc queries) | |||
| Linking total amounts | Excel Worksheet Functions | |||
Linear Mode
