Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Sum Cells on Non-Consecutive Worksheets

1. I agreed to these rules
Join Date
11th March 2006
Posts
3

## Sum Cells on Non-Consecutive Worksheets

Sorry I'm sure this has been asked many times and I looked through the forum and searched the question but I haven't found the answer. I am rusty and returning to excel after a lenghty break.

When adding cells from separate worksheets in the same spreadsheet, what is the formula?
For example, if I am adding B4 from a worksheet named dog and B4 from a separate worksheet named cat I am using =dog+cat!B4 .

This gives me the #VALUE! error. I also tried using parenthesis but it made no difference.

Thanks a lot for the help

Excel Video Tutorials / Excel Dashboards Reports

2. Super Moderator
Join Date
18th November 2004
Location
God's Own Country
Posts
4,504

## Re: adding cells in different worksheets

Hi mikeinc,

Welcome to ozgrid!

Try,

=SUM(dog:cat!B4)

HTH

3. I agreed to these rules
Join Date
11th March 2006
Posts
3

## Re: adding cells in different worksheets

Hi and thank you.

I should have been more clear. There are actually seven separate worksheets I want to pull formulas from. So again, for example the formula I use is:

=SUM(MBNA!B4+USBank!B4+Chase!B4+SI!B4+US!B4+PA!B4+Noa!B4)

That gives me the same #VALUE! error and its I'm going nuts. I know it's something similiar and I will be annoyed for not remembering.

Excel Video Tutorials / Excel Dashboards Reports

4. ## Re: adding cells in different worksheets

Hi,

Try: =SUM(MBNA!B4,USBank!A4,Chase!A4,SI!B4,PA!B4,Noa!B4)

5. I agreed to these rules
Join Date
11th March 2006
Posts
3

## Re: Sum Cells on Non-Consecutive Worksheets

COMMAS!

D'oh!

THANK YOU VERY MUCH for helping me and correcting my thread title.

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno