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

G

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"

Shane Devenshire said:
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
 
M

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top