For your tests, I think you need

=IF(A1DATE(2006,1,1),SUMIF(A:A,B4,D:D),0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"adscrim" wrote in
message ...

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