Here is a potentially easier solution, where everything in [] gets replaced by your specific ranges and criteria cell names:
=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, and will help you avoid false zeros.
The logic here is IF count finds at least one match, THEN add up the items with a match, ELSE return a blank.
Bookmarks