SumIFS Formula Issue

Michelle McN

Hi

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

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_range2​criterion2​... ])

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_range2​criterion2​... ])

Michelle McN

@Darren Mullen - Thanks I've got it work