April 30th, 2010, 01:41 PM
posted to microsoft.public.excel.newusers
|
|
Comparing, Matching, and Sum formula
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"ma" wrote in message
...
Thank you. I went with the second formula and it worked!
"T. Valko" wrote:
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.
.
|