SUMIFS function with ability to return blank if cell is blank


I am trying to establish a formula that will SUMIFS when multiple criteria is met yet when there is none of the criteria is met, leave cell blank. The formula that I have used in the past included the "IFERROR" function yet it doesn't work

=IFERROR(SUMIFS({Battery Scorecard Raw Data 2}, {Location}, "Richmond, KY", {Wk}, "35"), "")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!