| 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 |
| 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 | |||
Threaded Mode
