Average the total of 3 columns

[belvy123]

Hello all
I need a formula that will give me the average of the total of three columns
starting with the second non blank row in each of the three columns.

 

[Bob Phillips]

Here is one brute force method

=AVERAGE(SUM(D1100,-INDEX(D1100,MIN(IF(D1100<>"",ROW(D1100))))),SUM(F1:F100,-INDEX(F1:F100,MIN(IF(F1:F100<>"",ROW(F1:F100))))),SUM(I1:I100,-INDEX(I1:I100,MIN(IF(I1:I100<>"",ROW(I1:I100))))))

it is an array formula, so commit with Ctrl-Shift-Enter, not just Enter

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)