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.

Best Answers