Comparing, Matching, and Sum formula

  • Thread starter Thread starter ma
  • Start date Start date
M

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.
 
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.
 
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
 
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)
 
Back
Top