Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: kinkyparamour: Adding cells in multiple worksheets

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Blue River Services, Inc.
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How about if I send you my workbook to look at? I'm not sure how to explain what I am doing wrong. Thanks for your help.

    Karen

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    email to me if you like, david@monnetqos.com

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Karen,

    If Dave has not been able to help please feel free to send me your file. I will be happy to look at it for you............

    Kinkyparamour@AOL.com

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Karen,

    Did the changes made to your spreadsheet work for you?


    Denny

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    reviewed the worksheet, user wants to add cells from separate worksheets adding zero value where null.

    i suggested the following but thought somebody might be able to suggest more succinct formula...

    =if(isnumber('sheet1'!a1),'sheet1'!a1,0)+if(isnumber('sheet2!a2),'sheet2'!a2,0)+...etc

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



    I added the following to her worksheet and it worked great.

    =SUM('03-12'!$F$24,'03-22'!$F$24,'03-31 CG'!$E$24,'03-31 PC'!$E$24)

    I also made a couple of other changes to the workbook for her while i was in there. She E-mailed me today saying she was very happy with the help you and I supplied.

    Denny

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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