SumIFS Formula Issue

Options

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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!