Count If and Not blank

EmilyE · 06/28/21

Hey everyone, I am trying to count cells in a column where one column is not blank and cells in the other column matches a certain criteria.

The columns are:

Responsible Department - I want to count the cells in this column that are not blank

and

Program Name - Here is the Criteria - I want to count the cells in the Responsible Department column if the cell in this column matches "USP"

I have looked through the forums and can't seem to find a formula that would work (or one that I am doing right :) )

Thanks in advance for any help!

Bassam Khalil · 06/28/21

Hi @EmilyE

Hope you are fine, please try the following formula:

=IFERROR(COUNTIFS([Responsible Department]:[Responsible Department], NOT(ISBLANK(@cell)), [Program Name]:[Program Name], "USP"), "")

Bassam Khalil · 06/28/21

Hi @EmilyE

Hope you are fine, please try the following formula:

=IFERROR(COUNTIFS([Responsible Department]:[Responsible Department], NOT(ISBLANK(@cell)), [Program Name]:[Program Name], "USP"), "")

EmilyE · 06/29/21

That did it!

Thank you so much! I haven't had much experience with the ISBLANK formulas.

I appreciate your help!

Bassam Khalil · 06/29/21

@EmilyE

You are welcome and I will be happy to help you any time. Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful".

Bassam Khalil · 06/29/21

@EmilyE

Thanks for the nice and quick response

Andrée Starå · 06/29/21

Hi @EmilyE

I hope you're well and safe!

To add to Bassam's excellent advice/answer.

Here's another option for the ISBLANK part that I personally prefer.

=IFERROR(COUNTIFS([Responsible Department]:[Responsible Department], <>"", [Program Name]:[Program Name], "USP"), "")

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!