Formula Help - multiple criteria & ranges
I need HELP. I have been hitting my head against a wall trying to write a formula to calculate across different ranges and criteria. See photo for example of data. My formulas are not working out.
What I am trying to calculate is: Countifs
1) All PEM except PAC Support Center
2) Do not include rows with "opted out" checked
3) Any status except "connected"
4) kick-off is yes
5) risk is low
Thank you to any/all who can offer suggestions!
Help Article Resources
Check out the Formula Handbook template!