Assistance Needed (#INVALID DATE TYPE)

Kevin Sinclair

I have a sheet with multiple rows and columns. Two of the columns are for Recruitment Stage and Recruitment Priority. Recruitment Stage has (7) dropdown values, and Recruitment Priority has (6) dropdown values. I'm attempting to use a COUNTIFS statement to produce a total count of partners who are either in the 3-Introduction or 4-Engaged (Recruitment Stage), and are labeled as Priority (Recruitment Priority). I created the following formula, but receive a response of #INVALID DATE TYPE. What am I doing wrong?

=COUNTIFS({Alteryx Recruitment & Onboarding Tracker Range 1}, ="3-Introduction") = OR({Alteryx Recruitment & Onboarding Tracker Range 1}, ="4-Engaged") = AND({Alteryx Recruitment & Onboarding Tracker Range 2}, ="Priority")

Leibel S

@Kevin Sinclair

See below:

=COUNTIFS({Alteryx Recruitment & Onboarding Tracker Range 1}, OR(@cell="3-Introduction", @cell="4-Engaged"), {Alteryx Recruitment & Onboarding Tracker Range 2}, @cell="Priority")

Leibel S

@Kevin Sinclair

See below:

=COUNTIFS({Alteryx Recruitment & Onboarding Tracker Range 1}, OR(@cell="3-Introduction", @cell="4-Engaged"), {Alteryx Recruitment & Onboarding Tracker Range 2}, @cell="Priority")

Kevin Sinclair

@Leibel Shuchat, thank you so much for the assistance! I truly appreciate it! :)