assigning appropriate values to the points

Hi,

OK I can see that your -1.221 in G1 is an average of itself, i.e. G1, and is therefore circular. But it's not clear where the requirements of your first post fit in. i,e. the restriction on B=F & A=E. There are no rows where this condition is met.

Perhaps it would help if you'd describe in narrative form what you are wanting to do.

I did look at your latest sheet today and I repeat, I still don't understand

Tell me how you calculate G1 as -1.221. It's referring to itself and therefore being circular makes no sense. In fact if you hit the F2 key to edit it and immediately hit the Enter key you'll find it evaluates to zero.

Manually add some sample results that you expect to see - don't use any formulae, tell us which are the results cells and importantly describe in a narrative how you calculated them.