SUMIF function help
 

I have a SUMIF formula that I cannot get to work. I dont know how to set
the criteria to accept less than or equal to. Its for summing balance of
vacation days up to the current date. Heres my formula so far.

=SUMIF(I4:BJ4,I4:BJ4<=$F$2,I5:BJ5)

Thanks for your help.


--
CarFreek
------------------------------------------------------------------------
CarFreek's Profile: http://www.excelforum.com/member.php...o&userid=24334
View this thread: http://www.excelforum.com/showthread...hreadid=379344

this will work for sure

=SUMPRODUCT((I4:bj4<=$F$2)*(I5:bj5))


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=379344

One way:

=SUMIF(I4:BJ4,"<=" & $F$2,I5:BJ5)

In article ,
CarFreek
wrote:

I have a SUMIF formula that I cannot get to work. I dont know how to set
the criteria to accept less than or equal to. Its for summing balance of
vacation days up to the current date. Heres my formula so far.

=SUMIF(I4:BJ4,I4:BJ4<=$F$2,I5:BJ5)

Thanks for your help.