Comparing, Matching, and Sum formula

[ma]

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.

 

[ozgrid.com]

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

 

[ma]

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.

 

[ma]

I appreciate your response.

Could you tell me how I would modify this so that it only sums what is B so
as long as the DATE is 2010,4,29 in column A? Currently, it is summing the
whole column even when the date changes. Example:

2010-04-29 2
2010-04-29 7
2010-04-29 1
2010-04-28 4
2010-04-28 3

Results:
10
7

 

[T. Valko]

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)

 

[ma]

Thank you. I went with the second formula and it worked!

 

[T. Valko]

You're welcome. Thanks for the feedback!