Only COUNTBLANK('s) if another column is not blank...

**stephen_** · 06-21-2012, 07:04 AM

Hope the title makes sense, I need to pick up blank cells where the same row in another column is not blank.

For example the table below should result in 1 - as there is only 1 row that matches the criteria of have col 1 being not blank and col 2 being blank.

SA1
SA2	2
	1

I was thinking a sumproduct might help but to no avail...

Please Login or Register  to view this content.

Also tried to no avail...

Please Login or Register  to view this content.

**Fotis1991** · 06-21-2012, 07:08 AM

Hi and welcome to the forum

One way is this.

=SUMPRODUCT((A7:A56<>"")*(B7:B56=""))

**stephen_** · 06-21-2012, 07:11 AM

Fotis - many thanks for the help and welcome! (I've added to your reputation).

Glad to see I was'nt a million miles off with the SUMPRODUCT, just making it too complicated!

PS Is there any need to add {}? (always get confused with these)...

**Fotis1991** · 06-21-2012, 07:30 AM

You are welcome.

Thank you for your intention to add in my reputation(I don't see your name in my list), but this is not the important thing. Important is that you find your solution.

Yes you had the correct logic.

No you don't need {} in SUMPRODUCT. In fact IS an Array formula, but does not need {}.