COUNTIFS & SUMIFS Not Grabbing Negative Values

I am using the following formula to grab data for Table 1 from Table 2 (which is on a different page , but in the attached example they are on the same page).

=IF(COUNTIFS(B$25:B$38,">=0",$I$25:$I$38,$A$1,$A$25:$A$38,$A6)>=1,SUMIFS(B$25:B$38,$I$25:$I$38,$A$1,$A$25:$A$38,$A6),"")

It does well grabbing all data which are either 0 or they are positive, but negatives turn up as missing. I know that the ">=0" is the issue, but was having issues getting errors when that particular year did not have that particular holiday which is in cell A1.

Any ideas!!!

Jeff

Cross post

http://www.ozgrid.com/forum/showthread.php?t=191763

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