Using COUNTIFS, and/Or


I am trying to total anything from a sheet that is BLANK in "Supplier Email" AND Priority is HIGH

AND, IF any of the following are checked:

  • Completed (AP)
  • Invite Sent
  • Will Not Use

Using the formula below, it doesn't seem to work.

=COUNTIFS({Supplier Email}, <>"", {Priority}, [Total Suppliers]@row, (OR{Completed (AP)}, 0, OR{Invite Sent}, 0, OR({Will Not Use}, 0,)

Any help is appreciated! Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!