View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default how do I add a spreadsheet into a new sum? adding across spreadshe

=sum(1:3!c3)
add sheets BEFORE sheet 4

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jane" wrote in message
...
Ok, so I have this formula
=SUM('2'!C3,'3'!C3,'1'!C3)

but I will need to eventually add more spreadsheets into that sum.
Instead
of having to type that in each time, is there another formula/function
that i
can use? (Adding across spreadsheets?)

Thanks!
-Jane