adding columns if the dates are the same and getting OT hours

[Griffey5]

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"

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

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

 

[Max]

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
---