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.

Find more posts tagged with

Accepted answers

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"

All comments

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"

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.