SUMIFS - adding specific column if another blank

[FLOVETT]

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.

 

[Keebellah]

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

 

[flovettsr]

Thanks,
you did what I needed.