adding up values on another sheet problem

[WylieDude]

I am trying to do some basic math from the values stored in another sheet,
below is my attempt which brings back an error. Any help appreciated. thanks

=EIsummary!SUM(C9:C15)

=sheetName

 

[Peo Sjoblom]

=SUM(Elsummary!C9:C15)

there is a method where you don't have to think about this, just type =SUM(
then click the sheet tab you want to sum with the mouse and then select the
cells,
then end by pressing enter

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[WylieDude]

Your simple solution works great however what would be the best way to go
about it if the values needed are on two different sheets?

Thanks

 

[Ragdyer]

=SUM(Sheet1:Sheet2!C9:C15)

For 3 sheets:
=SUM(Sheet1:Sheet3!C9:C15)

If you wanted 4 sheets,
And ... if your sheets were named:
Tom - Dick - Harry - Mary,
*AND*, they were in that order:

=SUM(Tom:Mary!C9:C15)

 

[Peo Sjoblom]

Or if sheets are added, create 2 dummy sheets that can be hidden that will
always be first and last

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon