Trying to tally a column within a set of results

jessicawstage

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

Paul Newcome

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

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.