SUMIFS function with ability to return blank if cell is blank

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!