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

Believe you have Shane's formula below in C2, copied down:
=SUMIF($A$2:$A2,A2,B$2:B2)

So, if you want to calc the OT (ie total hours 40 per date) if any,
for each date in A2 down, let's just use col D

Put in D2: =IF(SUMIF(A:A,A2,B:B)40,SUMIF(A:A,A2,B:B),"")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Griffey5" wrote:
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"