Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum over ranges on another worksheet
I am trying to sum a group of cells contained on another worksheet within the
same file. The worksheet is named "Podiums & Carts". The formula that is causing the error is +SUM('Podiums & Carts'!T46:53+'Podiums & Carts'!T61:65+'Podiums & Carts'!T68:T71+'Podiums & Carts'!T73:T76+'Podiums & Carts'!T57) Any assistance would be appreciated. Jon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum over ranges on another worksheet
try instead:
=SUM('Podium & Carts'!T46:T53,'Podium & Carts'!T61:T65,'Podium & Carts'!T68:T71,'Podium & Carts'!T73:T76,'Podium & Carts'!T57) You don't need the + signs in the SUM function, each separate range is separated (in English version, it is by comma), and your first 2 ranges are missing the column reference of the second part of the range. -- ** John C ** "jmcclain" wrote: I am trying to sum a group of cells contained on another worksheet within the same file. The worksheet is named "Podiums & Carts". The formula that is causing the error is +SUM('Podiums & Carts'!T46:53+'Podiums & Carts'!T61:65+'Podiums & Carts'!T68:T71+'Podiums & Carts'!T73:T76+'Podiums & Carts'!T57) Any assistance would be appreciated. Jon |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum over ranges on another worksheet
What kind of error?
=SUM('Podiums & Carts'!T46:53,'Podiums & Carts'!T61:65,'Podiums & Carts'!T68:T71,'Podiums & Carts'!T73:T76,'Podiums & Carts'!T57) don't use plus signs within a sum function however that wouldn't cause an error. -- Regards, Peo Sjoblom "jmcclain" wrote in message ... I am trying to sum a group of cells contained on another worksheet within the same file. The worksheet is named "Podiums & Carts". The formula that is causing the error is +SUM('Podiums & Carts'!T46:53+'Podiums & Carts'!T61:65+'Podiums & Carts'!T68:T71+'Podiums & Carts'!T73:T76+'Podiums & Carts'!T57) Any assistance would be appreciated. Jon |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum over ranges on another worksheet
Didn't notice you were omitting the column headers, when you do a thing like
this it is better to type the equal sign, then SUM( and then go to this particular sheet, select the ranges you want by holding down the ctrl key and then select the next range etc. That way Excel will give you all the necessary data. -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... What kind of error? =SUM('Podiums & Carts'!T46:53,'Podiums & Carts'!T61:65,'Podiums & Carts'!T68:T71,'Podiums & Carts'!T73:T76,'Podiums & Carts'!T57) don't use plus signs within a sum function however that wouldn't cause an error. -- Regards, Peo Sjoblom "jmcclain" wrote in message ... I am trying to sum a group of cells contained on another worksheet within the same file. The worksheet is named "Podiums & Carts". The formula that is causing the error is +SUM('Podiums & Carts'!T46:53+'Podiums & Carts'!T61:65+'Podiums & Carts'!T68:T71+'Podiums & Carts'!T73:T76+'Podiums & Carts'!T57) Any assistance would be appreciated. Jon |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum over ranges on another worksheet
Thanks to all for the assist.
I stared at this for 15 minutes and never noticed the missing column references. Regards, "Peo Sjoblom" wrote: Didn't notice you were omitting the column headers, when you do a thing like this it is better to type the equal sign, then SUM( and then go to this particular sheet, select the ranges you want by holding down the ctrl key and then select the next range etc. That way Excel will give you all the necessary data. -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... What kind of error? =SUM('Podiums & Carts'!T46:53,'Podiums & Carts'!T61:65,'Podiums & Carts'!T68:T71,'Podiums & Carts'!T73:T76,'Podiums & Carts'!T57) don't use plus signs within a sum function however that wouldn't cause an error. -- Regards, Peo Sjoblom "jmcclain" wrote in message ... I am trying to sum a group of cells contained on another worksheet within the same file. The worksheet is named "Podiums & Carts". The formula that is causing the error is +SUM('Podiums & Carts'!T46:53+'Podiums & Carts'!T61:65+'Podiums & Carts'!T68:T71+'Podiums & Carts'!T73:T76+'Podiums & Carts'!T57) Any assistance would be appreciated. Jon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide and secure ranges in worksheet | Excel Worksheet Functions | |||
Mutiple Intersect Ranges for same worksheet - Help!! | Excel Discussion (Misc queries) | |||
Copy worksheet ranges from One Workbook to another from | Excel Worksheet Functions | |||
Vlookup with 2 ranges in one worksheet | Excel Worksheet Functions | |||
how do I name ranges in an Excel worksheet | Excel Worksheet Functions |