Having a problem with Countif formula not letting me count if it needs two criterias

Chad Rasmussen

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.

Stacey Carrasco

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

Chad Rasmussen

@Stacey Carrasco

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"

Stacey Carrasco

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

Chad Rasmussen

@Stacey Carrasco

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"