Trying to tally a column within a set of results

Hello. I've successfully pulled a my results using the formula below. Now I need to include another column to get a tally of the total minutes worked for these specific results. Can I do this in one statement?

=COUNTIFS([Project/Other Type]:[Project/Other Type], "Workshop/Professional Development", Phase:Phase, "Archive", [ID Tier]:[ID Tier], "Primary 1")

Here is the new column

Find more posts tagged with

Accepted answers

Paul Newcome

Your syntax is off. The SUMIFS function requires the range to be summed first followed by the "filtering" range/criteria sets.

All comments

Paul Newcome

You would use a SUMIFS.

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

jessicawstage

I'm getting the Incorrect Argument Set error.

This is what I'm trying:

=SUMIFS([Project/Other Type]:[Project/Other Type], "Workshop/Professional Development", Phase:Phase, "Archive", [ID Tier]:[ID Tier], "Primary 1", [Total Minutes Worked]:[Total Minutes Worked])

I've tried < and after total minutes worked and still the error. What am I missing?

Paul Newcome

Your syntax is off. The SUMIFS function requires the range to be summed first followed by the "filtering" range/criteria sets.

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.