View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jmcclain jmcclain is offline
external usenet poster
 
Posts: 48
Default 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