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
 Smartsheet Customer Resources
 62.9K Get Help
 379 Global Discussions
 210 Industry Talk
 441 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 300 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!