+ Reply to Thread
Results 1 to 5 of 5

Need to make Sum Column blank if all cells being added are blank

  1. #1
    Registered User
    Join Date
    05-27-2018
    Location
    Los Angeles
    MS-Off Ver
    MS365 (Mac) Version 2021
    Posts
    30

    Need to make Sum Column blank if all cells being added are blank

    Hi there everyone.

    So I have a tracker sheet that i've built to track jobs that are due day to day, but we now need to start tracking how much time spent per day on each job. So i set up columns W-AB for people to write in duration for every day of the week, and one for weekends (though hopefully nobody has to use that one), and column AC is for totals. What I'm trying to do is make sure that if all the days of the week are left blank, then the sum column stays blank too, because i have a master page that compiles everyone's info for the week onto one sheet, and i don't want it adding blank rows because there's a formula in one column that keeps returning 0.

    So, i tried the usual IF function, but i couldn't make that work with multiple columns for some reason.
    I tried SUMIF [=SUMIF(A1:E1,">1",A1:E1)], but that kept on returning 0, no matter what I tried as the criteria.

    I'm sure whatever i'm missing is a minor mistake somewhere, but I haven't been able to find anything posted in the forum that fixed the problem. Any help would be greatly appreciated.

    Thanks

    P.S. Sorry, I wanted to upload my excel doc, but i couldn't get the upload button to work.
    Attached Files Attached Files
    Last edited by AliGW; 05-28-2018 at 02:52 AM. Reason: Solved tag added cotrrectly.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need to make Sum Column blank if all cells being added are blank

    Hi, welcome to the forum

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.

    Maybe a small adjustment....
    =SUMIF(A1:E1,">0",A1:E1)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need to make Sum Column blank if all cells being added are blank

    A
    B
    C
    D
    E
    F
    1
    1
    0.5
    -10
    2
    3.5

    F1=SUMIF(A1:E1,">0")
    If you want to show "nothing", then...
    =IF(COUNTA(A1:E1),SUMIF(A1:E1,">0"),"")

  4. #4
    Registered User
    Join Date
    05-27-2018
    Location
    Los Angeles
    MS-Off Ver
    MS365 (Mac) Version 2021
    Posts
    30

    Re: Need to make Sum Column blank if all cells being added are blank

    the second one is exactly what i needed! Thanks for your help!

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: [Solved] Need to make Sum Column blank if all cells being added are blank

    happy to help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 03-01-2018, 12:16 PM
  2. Replies: 1
    Last Post: 07-22-2016, 04:03 PM
  3. [SOLVED] How to make cells blank when referring to another blank cell
    By Tinwelende in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-05-2014, 06:09 AM
  4. [SOLVED] Blank cells added to database
    By tapsmiled in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-05-2014, 03:25 PM
  5. How can I make a macro ignore blank cells? - Blank Cells have formulas
    By mz1161 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2013, 08:54 AM
  6. Replies: 0
    Last Post: 03-05-2013, 09:22 AM
  7. [SOLVED] Blank Cells Getting Added
    By dadrew in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 09-11-2012, 03:01 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1