SUMIFS: If no criteria match, leave cell blank, else return value

Originally Posted by KCchristoph

=IF(COUNTIF([criteria range], [criteria])>0, SUMIFS([sum range], [criteria range], [criteria]), "")

example: =IF(COUNTIF(H:H, A2)>0, SUMIFS(I:I, H:H, A2), "")

This will give you back a blank whenever there isn't a data match to sum,...

While I am getting the correct value when there is data that matches the criteria, I am still getting a zero when there isn't anything to sum. Where am I going wrong in the formula?

=IF(COUNTIF($G3:$G27, ">0"), SUMIFS($G3:$G26, $A3:$A26, TODAY(), $H3:$H26, "Admin"), " ")

Thank you for your help.