Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I add and IF function to a SUMIF function?
I need to sum values in a list that match other values and know that this can be done via the SUMIF function. However I also need to split the values based on a second numeric criteria. Does anyone know how this can be done. I thought about adding an IF function to the crtieria in the SUMIF. eg =SUMIF(A:A,B4&IF(A1DATE(2006,1,1),D:D) but can't get it to work. Any help would be greatly appreciated. Adam -- adscrim ------------------------------------------------------------------------ adscrim's Profile: http://www.excelforum.com/member.php...o&userid=30636 View this thread: http://www.excelforum.com/showthread...hreadid=502907 |