Set up COUNTIFS with muliple "<>"

Options

I am trying to make this work. I want the formula to count all the store numbers except for the ones where the Contract Status is not equal to several options in the Contract Status column. Not sure where I am going wrong.

=COUNTIFS({Circle K Summary Data Store #}, {Circle K Summary Data Contract Status}, <>"Submitted to CK", {Circle K Summary Data Contract Status}, <>"PSA Sent to Buyer", {Circle K Summary Data Contract Status}, <>"LOI Accepted", {Circle K Summary Data Contract Status}, <>"Drafting PSA", {Circle K Summary Data Contract Status}, <>"Closing", {Circle K Summary Data Contract Status}, <>"CK Submitted for Approval", {Circle K Summary Data Contract Status}, <>"Closed")

As a side note: If I use =COUNT({Circle K Summary Data Store #})- I do get the total number of rows of 272.


Thanks.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!