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
Check out the Formula Handbook template!