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.
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
-
33 KB Views: 39