Calculate based on highest values.

Hello All,

I have this file were in sheet1 there is 5 people for now.They are each given a list to place certain bids in.

if for example sheet1 J3 is greater than K3 and if sheet2 numbers in F3 ,G3 exactly match these numbers then person 1 gets 3pts
if j3 is greater than k3 but the numbers in F3,G3 are not the same then they get 1 point.

if K3 and J3 are equal and match sheet2 numbers then they again get 3pts but again if they are the same (J3,K3) but different to sheet2 F3,G3 and sheet2 numbers are
equal they get 1 point.
The values in sheet1 won't be calculated until values in sheet2 cols F & G are filled in each week.

I can do this in formula's but i won't be running this workbook and i know it will be messed up,so i think if this could run with vba then it can't be messed up.
I know i can protect the sheet,but i would like to study a vba solution.

I have attached a mocked up example.

Thanks for any help with this.

Based on your "rules", I dont agree with some of your sample answers...

	J	K	L	M
2	Person 1		Total
3	45	3	1	1
4	97	98	0	0
5	16	25	1	0
6	17	73	1	0

In M, i have my answers using this, copied down...
=IF(J3>K3,IF(AND(J3=Sheet2!$F3,Sheet1!K3=Sheet2!$G3),3,1),0)

if j3 is greater than k3 but the numbers in F3,G3 are not the same then they get 1 point.

J5<K5, answer should be 0, you have 1
J6<K6, answer should be 0, you have 1