Are you putting the "place" (1,2,3, or 4) in the same cell as the IF
function, thereby overwriting it?
If you put the "place" in column D, then put the IF functions in column
E and then sum column E.
in cell E3:
=IF(D3=1,3,-1)
If the "place" is 1, then put a 3 in here, otherwise put -1 in here.
--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile:
http://www.excelforum.com/member.php...o&userid=27741
View this thread:
http://www.excelforum.com/showthread...hreadid=474534