1: =SUMPRODUCT((B3:B6>40)*(B3:B6-40))
2: =B3+B3/SUM($B$3:$B$6)*15 and fill down.
Bob Umlas
Excel MVP

"KristopherJensen" <KristopherJensen@discussions.microsoft.com> wrote in
message news:E9D1208E-966A-437F-9C7C-FD2D59949F7E@microsoft.com...
> Hi,
>
> Im not quite new at using Excel, but I have decided to try to take on new
> challenges and I need some help in relation to that.
>
> #1:
> I want to make some calculations on 4 values, lets say that they are
> located
> in B3:B6. I to find out if each value exceeds the number 40, and if it
> does
> the exceeding ammount should be added in B7. For instance if the values
> are
> 30/41/60/10 then B7 would show the number "21". How is this possible?
>
> #2:
> If I have B2:B6 looking like this again:
> B3 30
> B4 40
> B5 60
> B6 10
> Total of 140.
> And I want to add 15 ponts in total to these numbers, but it should be
> done
> according to the % distribution, so that B3 would get 21.4% of the 15
> points,
> B4 would get 28.7% of the 15 points and so on. I want it to be added in a
> new
> collum. Is this possible?
>
> Thanks in advance