Try this:

H1 = 1/3/2009

=SUMPRODUCT(--(A1:A10=H1),C1:C10+E1:E10)

--
Biff
Microsoft Excel MVP


"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