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

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

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

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

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