Sum over ranges on another worksheet

[jmcclain]

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

 

[John C]

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.

 

[Peo Sjoblom]

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

 

[Peo Sjoblom]

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

 

[jmcclain]

Thanks to all for the assist.

I stared at this for 15 minutes and never noticed the missing column
references.

Regards,