COUNTIFS Fomula

I created a COUNTIFS formula in Excel which would count the values "Expired" and "Overdue" and add the total's together.

Excel Formula: =SUM((COUNTIFS(C:C, "CO-CURRIC-COI",J:J,"Expired")),(COUNTIFS(C:C, "CO-CURRIC-COI",J:J,"Overdue")))

When trying to emulate it in Smartsheet, I get a #unparseable error. Not sure what I am doing wrong and if there is a better formula to achieve it, I'm all for it.

SmartSheet Formula: =SUM((COUNTIFS({Chancellor's Office - Presidential Evaluat Range 3}, CO-CURRIC-COI), {Chancellor's Office - Presidential Evaluat Range 1,"Expired",),(COUNTIFS({Chancellor's Office - Presidential Evaluat Range 3},CO-CURRIC-COI,{Chancellor's Office - Presidential Evaluat Range 1},"Overdue"))

Find more posts tagged with

Sheets

Formulas

Accepted answers

Jason Duryea

It looks like the syntax in your formula is causing the issue. There are missing "" and extra commas and parenthesis. Try the formula below.

=SUM(COUNTIFS({Chancellor's Office - Presidential Evaluat Range 3}, "CO-CURRIC-COI", {Chancellor's Office - Presidential Evaluat Range 1}, "Expired"), COUNTIFS({Chancellor's Office - Presidential Evaluat Range 3}, "CO-CURRIC-COI", {Chancellor's Office - Presidential Evaluat Range 1}, "Overdue"))

All comments

Jason Duryea

It looks like the syntax in your formula is causing the issue. There are missing "" and extra commas and parenthesis. Try the formula below.

Fernando Leal

Jason. My hero! Thank you. Of course it would be something simple like that. Appreciate your help!

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.