SUMIFS - adding specific column if another blank

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

FLOVETT

Felton
Thread Starter
Joined
Sep 17, 2007
Messages
79
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.
 

Attachments

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
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
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Top