COUNTIFS and with 2 different values in same column with a value in another column?

I have two different columns lets say "Colone" and "Coltwo". Colone has a value GZ22 and GZ21. Coltwo column has two activities "Completed" and "Just Completed"

I'm trying to create a formula to count which counts the activity "Completed " that are done in GZ22 with the activity "Just Completed" that are done in GZ22. and both columns "Colone" and "Coltwo" are in a same sheet named CP.

i am using the formula

=COUNTIFS({CP Colone}, "GZ22", {CP Coltwo}, "Completed"})+ =COUNTIFS({CP Colone}, "GZ22", {CP Coltwo}, "Just Completed")

i get "unparseable" as the answer.

Can anyone help me solve this?

Thanks!

Find more posts tagged with

Accepted answers

Christina09

You need to take out the "=" in the second part of the formula.

Try =COUNTIFS({CP Colone}, "GZ22", {CP Coltwo}, "Completed"})+ COUNTIFS({CP Colone}, "GZ22", {CP Coltwo}, "Just Completed")

All comments

Christina09

You need to take out the "=" in the second part of the formula.

Try =COUNTIFS({CP Colone}, "GZ22", {CP Coltwo}, "Completed"})+ COUNTIFS({CP Colone}, "GZ22", {CP Coltwo}, "Just Completed")

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.