COUNTIFS & SUMIFS Not Grabbing Negative Values

Originally Posted by nflsales

instead of Countifs & Sumifs you can use
=IFERROR(LOOKUP(1,1/($A$25:$A$38&$I$25:$I$38=$A6&$A$1),B$25:B$38)*1,"")
Try this in B6 and copy across

This works great Siva! The only issue that I am having is that if there is a blank cell it returns a zero. Is there a way to correct that?

Jeff