COUNTIFS Issues

Abbey Owens

I am having problems getting COUNTIFS to work. I have two different formulas I am trying to set-up in different columns. I would also like cells that return as zero to change to blank. Does anyone know how I can fix my formulas and also set them up for "0" to change to blank?

1.) I need a formula that counts the amount of registrants from a specific clinic within a specific town.

=COUNTIFS({OKFresh Enrollment Form Range 1}, =[Primary Column]@row, {OKFresh Enrollment Form City}, "Oklahoma City")

2.) I also need to count the amount of registrations per clinic per year. I am having the same problem with this as above.

=COUNTIFS({OKFresh Enrollment Form Clinics}, =[Primary Column]@row, {OKFresh Enrollment Form Created}, YEAR({OKFresh Enrollment Form Created}) = 2020)

Andrée Starå

Hi @Abbey Owens

I hope you're well and safe!

Try something like this.

1.

=IF(COUNTIFS({OKFresh Enrollment Form Range 1}, [Primary Column]@row, 
{OKFresh Enrollment Form City}, "Oklahoma") = 0, "", 
COUNTIFS({OKFresh Enrollment Form Range 1}, [Primary Column]@row, 
{OKFresh Enrollment Form City}, "Oklahoma"))

2.

=(COUNTIFS({OKFresh Enrollment Form Clinics}, [Primary Column]@row, 
{OKFresh Enrollment Form Created}, YEAR(@cell) = 2020))

Did that work/help?

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!