View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jane Jane is offline
external usenet poster
 
Posts: 202
Default how do I add a spreadsheet into a new sum? adding across spreadshe

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