Average of difference between dates greater than zero
Hello Biff,
...
If you want it to be more robust against row insertions:
=AVERAGE(IF((MOD(ROW(O12:O20)-ROW(O12),2)=0)*(O12:O20-O90),O12:O20-O9))
...
Insert a row after row 12 or before 20 :-)
SCNR,
Bernd
|