One possible way


=SUMPRODUCT(--(A2:A10=DATE(2009,1,4)),(C2:C10)+(E2:E10))

--


Regards,


Peo Sjoblom


"Mona" wrote in message
...
Thanks in advance!

Data
A B C D E
1/2/2009 3 1 3 2
1/3/2009 2 5 2 6
1/4/2009 1 3 1 3

If column A=1/3/2009 then add column C + column E. Thanks a bunch