Thread
:
how do I add a spreadsheet into a new sum? adding across spreadshe
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett