Summing with maximums

[hossa_dude]

Hi Guys...yet another problem.
I'll have to do some calculations for my HR dept.
Therefore, I get a list of how many hours a person worked per day in
given calendar month.
What I want to do is sum those figure for the respective month.
However, if a person works more than 8h a day, 8 should be the maximu
number to be included in the summing. On the contrast, if he work
below 8h per day, the actual figure should be included, eg.
Day 1: 8
Day 2: 7.5
Day 3: 9
The correct sum should equal: 23,5 (i.e. 8, 7.5 and 8) and NOT 24,5 (8
7.5, 9)

Any idea on how to do that?

Kind regards
Joer

 

[Dave R.]

=SUM(IF(A3:A5>8,8,A3:A5))

entered with CTRL SHIFT ENTER

 

[hossa_dude]

On word: perfect....any other words? Thank you
That helped....didn't know that it was so easy.....
Great work..