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
|