Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Sum Cells on Non-Consecutive Worksheets

  1. #1
    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. #2
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,337

    Re: adding cells in different worksheets

    Hi mikeinc,

    Welcome to ozgrid!

    Try,

    =SUM(dog:cat!B4)

    HTH

  3. #3
    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. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,713

    Re: adding cells in different worksheets

    Hi,

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

  5. #5
    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.

    Incredibly friendly and helpful board.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Find Largest Difference Between Two Consecutive Cells
    By l_a_andrews in forum EXCEL HELP
    Replies: 2
    Last Post: March 21st, 2008, 03:45
  2. Replies: 2
    Last Post: March 19th, 2008, 07:05
  3. Replies: 8
    Last Post: January 12th, 2007, 07:10
  4. Paste Cells based on number of consecutive similar values
    By FreddyKrueger in forum EXCEL HELP
    Replies: 3
    Last Post: January 27th, 2005, 16:40

Bookmarks

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