COUNTIFS on the same column and COUNTIFS on other columns
Hi
I am trying perform the COUNTIFS function and can't get this to work. So what I need to count is the following
- Count if criteria is "s" in the function column
- Count if criteria is "Med" in the priority column
- Count if criteria is "No" in the project column
- And from the same project column I need to count if criteria is "partial" also.
My formula has step 1-3 but I can't figure out how to include step 4.
=COUNTIFS(Functions2:Functions290, "s", Priority2:Priority290, "Med", Project2:Project290, "No")
Any chance someone knows how to do this? Criteria from multiple columns and then 2 criteria from the same column.
Any help would be greatly appreciated.
Thanks
Comments
-
How can your project field say both No and partial at the same time? That may be the issue here? are you trying to count if it either has the word no or the word partial?
Did you try?
=COUNTIFS(Functions2:Functions290, "s", Priority2:Priority290, "Med", Project2:Project290, "No",Project2:Project290, "partial")
-
Hi thanks for responding. Yes I tried that and it didn't work. Do you have any other ideas?
-
I don't really understand what you are trying to do. You have a project field. Either it will say "No" or it will say "partial" if it is only one word it cannot say both at the same time. What are you really trying to count
-
What you need to do is add two countifs together. The first one would check for the requirements plus NO, and the second would count the requirements plus the Partial. Try this one.
=COUNTIFS(Functions2:Functions290, "s", Priority2:Priority290, "Med", Project2:Project290, "No") + COUNTIFS(Functions2:Functions290, "s", Priority2:Priority290, "Med", Project2:Project290, "Partial")
Basically, you adding the result of two countifs together.
-
It worked and it makes total sense now that I see the formula. Thank you so much. I am just learning how to do all the formulas. I really appreciate your help.
Thank you!!!!!
-
Glad I could be of help!
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!