SumIFS Formula Issue

I need to count the number of total Artefacts if the Process column equals one of four process options.

I'm doing this calculation in the Sheet Summary function and I've followed the help guide to set up the formula but I'm still having issues.

Here is what I have:

=SUMIFS(Total # of Artefacts:Total # of Artefacts,>0,[Process]:[Process], "Create and Maintain item/project structure")

Thanks

Michelle

Find more posts tagged with

Formulas

Accepted answers

Darren Mullen

@Michelle McN Ahh, I should have checked the syntax before answering. You are missing the first range that you want to sum.

https://help.smartsheet.com/function/sumifs

SUMIFS( range, criterion_range1, criterion1, [ criterion_range2criterion2... ])

All comments

Darren Mullen

@Michelle McN your range references "Total # of Artefacts" need to be in square brackets since there are spaces in the name.

Like this:

=SUMIFS([Total # of Artefacts]:[Total # of Artefacts],>0,[Process]:[Process], "Create and Maintain item/project structure")

Michelle McN

Thanks @Darren Mullen however this formula returns "#invalid operation" as the result.

Darren Mullen

@Michelle McN Ahh, I should have checked the syntax before answering. You are missing the first range that you want to sum.

https://help.smartsheet.com/function/sumifs

SUMIFS( range, criterion_range1, criterion1, [ criterion_range2criterion2... ])

Michelle McN

@Darren Mullen - Thanks I've got it work

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.