Formula that counts the number of rows a given distance away with a specific value
I'm trying to develop a column function that will count every row of my data table where
1) The :X and :Y coordinates are less than 2 Euclidean distance away
&
2) The :Value is = 5
In this 5 by 5 grid every :Value is set to 1, except for the central datapoint (3,3) which has :Value = 5.
The datapoints in blue are <= 2 unites away from the central datapoint and thus get correctly count 1 datapoint in...