Hi @coolsac12
You can use this array formula instead:
=SUM(IF(ISNUMBER(B1:B14)*(A1:A14=D4),B1:B14))
Blessings!
Thanks JJV, that is much better and simple.Hi again!
Another solution could be:
=SUMIFS(B1:B14,A1:A14,D4,B1:B14,">0")
Or if you have negative values, could be:
=SUM(SUMIFS(B1:B14,A1:A14,D4,B1:B14,{">0";"<0"}))
Blessings to all!