# 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

Why should I rate a post?

Expand AllCollapse All

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