COUNTIFS Using And as well as Or
I am looking to have an information sheet that is looking for several criteria with "and" and "or".
For example, I want the formula to count if the other sheet has "Priority 1" and "John Doe" and a status of either 1 or 2 or 3.
I will have another cell on the information sheet for "Priority 2" and "John Doe" and a status of either 1 or 2 or 3.
I am not using children and the sheet I am referencing is one that I am shared with as Editor - cannot share, in case that is an issue.
Help Article Resources
Check out the Formula Handbook template!