Formula Help - multiple criteria & ranges
Hi community!
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!
Best Answer
-
@Samuel Mueller I don't know how to thank you!! It worked! I had no idea "<>" was even a thing. Problem solved - I should have posted this question sooner.
Thank you!!
Answers
-
Something like this should work:
=COUNTIFS(PEM:PEM, <>"Support Center", [Opted Out]:[Opted Out], 1, Status:Status, <>"Connected", [Kick-off]:[Kick-off], "Yes", Risk:Risk, "Low")
countifs has a criteria range, and then the criteria. The range is the column that has a criteria you want to count, and then the criteria for that range is what you want to count or not.
Checkboxes are 0 or 1. does not equal is the <>.
If you don't use an entire column for a range - all the criteria ranges musts be the same size.
Does that help?
-
@Samuel Mueller I don't know how to thank you!! It worked! I had no idea "<>" was even a thing. Problem solved - I should have posted this question sooner.
Thank you!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!