SUMIFS function with ability to return blank if cell is blank

Nanette.Murphy96461

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"), "")

Mark Cronk

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

Mark Cronk

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

Nanette.Murphy96461

It worked perfectly! Thanks Mark!