Adding multiple values simultaneously [SOLVED]

[mikmayer]

I have column A as Date and column B as points.


Column A looks like this:


7/26/2013

7/26/2013

7/26/2013

7/26/2013

7/27/2013

7/27/2013

7/27/2013

7/28/2013

7/28/2013

7/28/2013

7/28/2013


Next to each date there is a point value. I want to add up all of the points to a specific date. For example, for 7/26/2013, I want to auto sum all of those point values associated with 7/26/2013 in one cell.


I know I can use a pivot table but I'd like to do it through a formula.


Appreciate the help as always.

 

[Faseeh]

Hi,


Use

=SUMIF(A1:A11,A1,B1:B11)

, your data is in A1:B11. A1 is the date you want to sum for.


Regards,

 

[Hui]

or

=SUMIF(A$1:A$11,Date(2013,7,26),B$1:B$11)

or

=SUMPRODUCT((B1:B11)*(A1:A11=DATE(2013,7,27)))

 

[mikmayer]

Thanks to both! Works like a charm.