(Count if) And & Or
JKremer
✭✭✭✭
I need a formula that will count the number of rows with High priority and are New OR Open. I cannot figure this out, so any help is appreciated!
Tags:
Best Answer

@JKremer Here is my solution to a similar challenge:
I find AND and OR tricky. In this case, instead of OR, I just add two similar CountIFS statements because I know they are exclusive.
Make sense?
Dale
Answers

@JKremer Here is my solution to a similar challenge:
I find AND and OR tricky. In this case, instead of OR, I just add two similar CountIFS statements because I know they are exclusive.
Make sense?
Dale

That worked beautifully! Thank you so very much 😀😁
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!