COUNTIFS and AND

Paula M.

Hi there! I am trying to insert a formula that reads two columns from another sheet. I want to count the cells if one column equals the Primary column name in my new sheet and the other does NOT equal the status "Scheduling Complete". I can't figure it out! Below is what I currently have and have tried dozens of versions... Tried with/without AND also....

Thanks for your help!

=COUNTIFS({Interview Request Form - MASTER Coordinator}, [Primary Column]@row, AND([{Interview Request Form - MASTER Status}, <>"Scheduling Complete"]))

=COUNTIFS({Interview Request Form - MASTER Coordinator}, [Primary Column]@row, [{Interview Request Form - MASTER Status}, <>"Scheduling Complete"])

Sameer Karkhanis

@Paula M. Try this,

=COUNTIFS({Interview Request Form - MASTER Coordinator}, [Primary Column]@row, {Interview Request Form - MASTER Status}, <>"Scheduling Complete")

Sameer Karkhanis

@Paula M. Try this,

=COUNTIFS({Interview Request Form - MASTER Coordinator}, [Primary Column]@row, {Interview Request Form - MASTER Status}, <>"Scheduling Complete")

Paula M.

THANK YOU SO MUCH! I could not get this right! It worked great!