Counting with multiple columns and conditions

Lisa Wills

Hello- I'm trying to build a formula that accounts for more than one condition. In this case, I need it to pull counts by person and then by priority (i.e. P1, P2) references in another sheet. Any thoughts you have would be appreciated. Here's what I have so far.Thank you!

Lisa Wills

Please don't apologize. Formulas are not easy; especially for someone like me LOL! That worked- thank you so much for your help!

Paul Newcome

At least we were able to figure it out (eventually). Haha.

Happy to help. 👍️

Paul Newcome

Try removing the AND function (and corresponding parenthesis).

The COUNTIFS is designed to assume "and".

Lisa Wills

Here's what I removed- it still gave me the error message.

Paul Newcome

You accidentally removed the comma after "Yvette Wilkins". Throwing that back in there should have you up and running.

Lisa Wills

Thanks. I entered the comma and it added a "Total 6" in the formula? I clicked enter and it gave me the error message again.

Paul Newcome

Oops. My apologies. I missed the fact that there is no opening parenthesis after COUNTIFS and no closing parenthesis at the end in the one that was also missing the comma.

=COUNTIFS({range}, criteria, {range}, criteria)

Lisa Wills

No worries- I added the parenthesis but still no luck. Thoughts?

Paul Newcome

Ugh. I am so sorry. I keep missing the details. You have an extra closing curly bracket after "P1" that needs removed.

Lisa Wills

Please don't apologize. Formulas are not easy; especially for someone like me LOL! That worked- thank you so much for your help!

Paul Newcome

At least we were able to figure it out (eventually). Haha.

Happy to help. 👍️