COUNTIFS Help

Carlos Yanes

I'm trying to do a count if criteria within two columns meet particular criteria. I keep getting the unparseable error message. My formula is:

=COUNTIFS({NCO-SD Intake Range 1}, [Contact Email]7, AND{NCO-SD Intake Range 2}, [Assigned Totals]6))

If I do the formula with the first portion only or the second it works fine, but when i join them, that's when the issue comes up.

L_123

=COUNTIFS({NCO-SD Intake Range 1}, [Contact Email]7,{NCO-SD Intake Range 2}, [Assigned Totals]6)

You don't need the and statement, countifs just lets you keep typing in ranges and criteria.

L_123

=COUNTIFS({NCO-SD Intake Range 1}, [Contact Email]$7,{NCO-SD Intake Range 2}, [Assigned Totals]$6)

L_123

=COUNTIFS({NCO-SD Intake Range 1}, [Contact Email]7,{NCO-SD Intake Range 2}, [Assigned Totals]6)

You don't need the and statement, countifs just lets you keep typing in ranges and criteria.

Carlos Yanes

Thank you @L@123 ! That worked. How do I lock the formula, so it doesn't change as I drag it down?

L_123

=COUNTIFS({NCO-SD Intake Range 1}, [Contact Email]$7,{NCO-SD Intake Range 2}, [Assigned Totals]$6)

Carlos Yanes

Thank you! ;)