SUM of column wheren another column contains BLANK cells I\'m trying to come up

Question

SUM of column wheren another column contains BLANK cells

I'm trying to come up with a formula and need help. Column A has SOME blank fields, and there are numbers in ALL of the fields in column B. I would like a formula to sum ONLY the values in Column B where Column A is blank.

For Example:

Column A = Hardware, Training, (blank), Software, Hardwrarre, Hardwarre, (blank), (blank), Maintenance, Training, Hardware

Column B = 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100

In this scenario, the formula should come up with an answer of 300. How do I do this?????

Explanation / Answer

Try this:

=SUMPRODUCT(--(LEN(A1:A11)=0)*(B1:B11))

HTH :)

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.