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
Was this post helpful to you?

Why should I rate a post?



Expand AllCollapse All

Manage Your Profile |Contact us
© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use
|Trademarks |Privacy Statement



QuestionSuggestion for MicrosoftGeneral comment