Weighing Point Clusters

Hello !!!)
I wanted to ask your help it creating a unified formula for weighing certain point clusters. I have a list of points where each has a weigh attributed to it. I have a cluster dimension parameter which defines how many points will be in one cluster. I am able to find the number of points belonging to one cluster but I need to extend this further to perform calculation NOT on the points belonging to the cluster but –indirectly – on the WEIGHTS which belong to all the points in the cluster. At first I need to AVERAGE the weights belonging to the points in the cluster. I need a formula approach to this question as I am going to tweak it extensively in the future for all kinds of indirect array calculations. Please see the attached workbook which shows in detail how the calculations should be made using one of the clusters – lying around the 21 point as an example.
Thank you very much for your time!)
Dima

maybe someone can let me know if this is possible to do in principle?))
Thanks!)

Thank you very much for this post - yes your formula replicates the results of my formula - the cluster is a group of points which are close to any single point - the cluster size parameter defines the distance above or below a point where the point can fall to below to the cluster:

for example point - 20 - cluster size 3 - this means the cluster will contain all point which are larger than 17 and smaller than 23


I need to perform the calculations on the wights corresponding to the members of the cluster



thanks!!!!

hello ! I am able to calculate the average weight for the points which are equal to 20
=AVERAGE(IF($D$2:$D$32=20,$A$2:$A$32))
but when I add more conditions to the IF formula inside it shows zero - please tell me what is not working correct?)
Thanks!)

Ok i found the solution!) =average(if($d$2:$d$200>d7-$f$1,if($d$2:$d$200<d7+$f$1,$a$2:$a$200)))