Try this:

#1:
Two ways....
B7: =SUMIF(B3:B6,"40",B3:B6)-COUNTIF(B3:B6,"40")*40
or
B7: =SUMPRODUCT(--(B3:B640)*(B3:B6-40))

#2:
C3: =B3+(B3/$B$7)*15
(copy that formula down thru C6)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"KristopherJensen" wrote:

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