Sum multiple sheets

[Deano]

Hi All

Possibly a real easy question.

If I have a workbook with 3 sheets (ie: Sheet1, Sheet2 and Sheet3) and in Cell A1 of each sheet I have the number 100 stored.

In Cell a2 of Sheet1, what formula would I put in so as to sum the cells A1 of all three sheets?

Many thanks

 

[NBVC]

=SUM(Sheet1!$A$1:Sheet3!$A$1)

 

[Deano]

Hi NBVC

Thanks for the promt response.

I have copied the formula in and get a #VALUE result.

Any idea why?

 

[NBVC]

Sorry, I could have sworn that worked

Try this instead:

=SUM(Sheet1!A1,Sheet2!A1,sheet3!A1)

 

[Deano]

Thanks, that works.

 

[shades]

Here is the formula:

=SUM(Sheet1:Sheet3!$A$1)

 

[NBVC]

Here is the formula:

=SUM(Sheet1:Sheet3!$A$1)

Now I see where I messed up. It was that darn ! after the first sheet reference.

I new that formula worked. I thought I was going crazy. Sometimes the simplest things can drive you up the wall the most.

Thanks for clearing me up.

 

[shades]

Been there, done that, can't remember a thing.


Glad to help.