1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

SUMIFS - adding specific column if another blank

Discussion in 'Business Applications' started by FLOVETT, Dec 12, 2011.

Thread Status:
Not open for further replies.
  1. FLOVETT

    FLOVETT Thread Starter

    Joined:
    Sep 17, 2007
    Messages:
    79
    First Name:
    Felton
    I have been trying to figure a formula to add one column only if the results of another column is blank.

    I have used sumifs(ac:ac,ab:ab,"<>") and sumifs (ac:ac,ab:ab,""). In both cases, the total column is summed.

    I am using named ranges, I tried the names and the columns as well to no avail. I have been trying to solve for the past 2 days.
     

    Attached Files:

    FLOVETT, Dec 12, 2011
    #1
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    I hope you don't mind my saying I don't see what you're trying to do.
    Is it that you want to add BB is D is not blank? But the Sum of B:B will always be the same
    Or does it have to add all the B:B for those where column D is filled?
    Another thing, column D is NOT empty it contains a space so you will have to check on LEN(TRIM(D2))>0 instead of D2<>""
    I'm not that good with formula's and I would think of a macro but then you will have to tell me what the creiteria are for the SUM of B:B when D<> blank

    I've returned your sample with an idea of mine, Column F will containa 1 or a 0 depending if D is emply or not but I stiull don't have the rest of the criteria
     

    Attached Files:

    Keebellah, Dec 13, 2011
    #2
  3. flovettsr

    flovettsr

    Joined:
    Apr 1, 2011
    Messages:
    25
    Thanks,
    you did what I needed.
     
    flovettsr, Dec 14, 2011
    #3
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - SUMIFS adding specific
  1. Punctual

    Adding Page Numbers

    Punctual, Jan 26, 2020, in forum: Business Applications
    Replies:
    3
    Views:
    341
    Macboatmaster
    Jan 26, 2020
  2. DRGW

    Solved Adding time

    DRGW, Jan 4, 2020, in forum: Business Applications
    Replies:
    6
    Views:
    610
    cwwozniak
    Jan 31, 2020
  3. vane111297

    Adding two different formulas in one cell using Google Sheet

    vane111297, Nov 12, 2019, in forum: Business Applications
    Replies:
    0
    Views:
    553
    vane111297
    Nov 12, 2019
  4. Totores

    Adding custom library shapes to Adobe acrobat

    Totores, Apr 11, 2019, in forum: Business Applications
    Replies:
    0
    Views:
    462
    Totores
    Apr 11, 2019
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1030961

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice