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"
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
(in column "C") if the hours are over 40 for each day after it calculates the
hours in column "B"
Was this post helpful to you?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
Manage Your Profile |Contact us
© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use
|Trademarks |Privacy Statement
QuestionSuggestion for MicrosoftGeneral comment