=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.