Adding Cells in Multiple Worksheets
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: 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

     
    I am having trouble adding cells in multiple worksheets. The cells I want to add have formulas in them so that if there is no numbers to add, the cells will be blank. When I try to add the blank cells I get a #Value! error code. I have tried to use the sum function and the sumif and neither works. Any suggestions? I would gladly send the workbook to anyone who could look at it. The formulas in the cells that I am trying to add are: =IF(SUM(D6:D23)=0,"",SUM(D6:D23)). This is in cell D24 on several worksheets. If there are numbers in all of the cells I am trying to calculate, it works. If any of the cells are blank, I get the error code. Thanks in advance for any help anyone can give me.

    Karen

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

    Default

      
    Karenater

    I was just playing with your formula and in a blank cell I get a blank, no error. Maybe you could give more info as to what the problem is.


    Denny

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
  •  

 

 
DMCA.com