Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
Dynamic sumif function | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
how do you do a sumif function on more than one worksheet? | Excel Worksheet Functions |