adding columns if dates are the same
 

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

adding columns if dates are the same
 

Hi,

Try

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Griffey5" wrote:

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

adding columns if dates are the same
 

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

"Shane Devenshire" wrote:

Hi,

Try

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Griffey5" wrote:

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

adding columns if dates are the same
 

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Griffey5" wrote:

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

"Shane Devenshire" wrote:

Hi,

Try

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Griffey5" wrote:

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

adding columns if dates are the same
 

I have one other question for this formula. I want to be able to calculate
(in column "C") if the hours are over 40 for each day after it calculates the
hours in column "B"

"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Griffey5" wrote:

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

"Shane Devenshire" wrote:

Hi,

Try

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Griffey5" wrote:

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