Having a problem with Countif formula not letting me count if it needs two criterias
Ok I am stumped on this one. I have read through some articles and thought I had an answer but nope.
I am trying to do a countif formula for a sheet summary field. I want a count if the cell in Phase 1 Column says "Kong" and if the Team Completion % is 100%
Here is the Formula I am using
=COUNTIF([Phase 1 QE Work Package]:[Phase 1 QE Work Package], ="Kong") + =COUNTIF([Team Completion %]:[Team Completion %], =1)
Of course they work on their own. But when I try that formula it gives me an invalid operations error.
Best Answers
-
try adding the S at the end of COUNTIF and then you can add both your variables and remove the + sign
try =COUNTIFS([Phase 1 QE Work Package]:[Phase 1 QE Work Package], "Kong", [Team Completion %]:[Team Completion %], "100%")
although the 100% value may be .01 not sure try it out and see what you get
Senior Program Coordinator
De Anza College
-
Thank you for your help. I forget the COUNTIFS formula. Your formula was great the only thing I had to change was the end where is was the "100" had to be "1"
Answers
-
try adding the S at the end of COUNTIF and then you can add both your variables and remove the + sign
try =COUNTIFS([Phase 1 QE Work Package]:[Phase 1 QE Work Package], "Kong", [Team Completion %]:[Team Completion %], "100%")
although the 100% value may be .01 not sure try it out and see what you get
Senior Program Coordinator
De Anza College
-
Thank you for your help. I forget the COUNTIFS formula. Your formula was great the only thing I had to change was the end where is was the "100" had to be "1"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!