Hi,

I am not so familiar with the D-Functions and am struggling to get the correct formula.
(i've searched the forum but cannot find a similar problem)

In the criteria section of the formula i want to select cells that are not adjacent so i can create a list of D-averages

Daverage problem.xlsx

As you'll see in the example my problem cell is I6

Thanks for any advice to this (probably) simple problem