Try this...

=SUMIF(A:A,DATE(2010,4,29),B:B)

Better to use a cell to hold the date

D1 = 4/29/2010

=SUMIF(A:A,D1,B:B)

--
Biff
Microsoft Excel MVP


"ma" wrote in message
...
Thank you for your response.

How would I modify it so that it only summed column B so as long as Date=
2010,4,29 in any row of column A. Right now it's summing all of column B
even
when the date changes.

"ozgrid.com" wrote:

=IF(A1=DATE(2010,4,29),SUM(B:B),0)



--
Regards
Dave Hawley
www.ozgrid.com
"ma" wrote in message
...
Hello.

Column A has dates. The format is 2010-04-29. There are multiple rows
with
the same date.

Column B has numbers

Please, provide me the formula IF:

column A="2010-04-29" then SUM(B:B)

Thank you.