COUNTIFS and AND
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"])
Best Answer
-
@Paula M. Try this,
=COUNTIFS({Interview Request Form - MASTER Coordinator}, [Primary Column]@row, {Interview Request Form - MASTER Status}, <>"Scheduling Complete")
Answers
-
@Paula M. Try this,
=COUNTIFS({Interview Request Form - MASTER Coordinator}, [Primary Column]@row, {Interview Request Form - MASTER Status}, <>"Scheduling Complete")
-
THANK YOU SO MUCH! I could not get this right! It worked great!
Help Article Resources
Categories
Check out the Formula Handbook template!