SUMIF formula for Summary reporting


Hi all,

I am trying to create a sheet summary that shows totals for test results ("Failed", "Passed", "Retested", Pending"). I'm using the formula =SUMIF(Results:Results, @cell = "Pass") to pull the sum of tests passed under a "Results" Column, but this returning 0. :( I'm sure I'm missing something simple! Any tips?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!