adding columns if dates are the same

[Griffey5]

How do I add a column of numbers only if the dates in another column are the
same?

EX:

A B
c
1 1/9/08 16
16
2 1/9/08 24
40
3 1/10/08 32
32
4 1/10/08 36
68
If I place the formula in column "C" I want the dates that are the same to
continuously add until the next date occurs

 

[Shane Devenshire]

Hi,

Try

=SUMIF($A$2:$A2,A2,B$2:B2)

 

[Griffey5]

This didn't work. Is the formula an array?

Hi,

Try

=SUMIF($A$2:$A2,A2,B$2:B2)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Shane Devenshire]

Hi,

Here is the data I used:
A B C
1/6/2009 1 1
1/6/2009 4 5
1/6/2009 5 10
1/7/2009 2 2
1/7/2009 6 8
1/7/2009 7 15
1/7/2009 8 23
1/7/2009 3 26

The formula is not an array. Watch the $ signs they are mixed cell references
=SUMIF($A$2:$A2,A2,B$2:B2)

A2 contains the first date and B2 contains the first value. The formula was
entered in C2 and copied down.