Average the total of 3 columns

B

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.
 
B

Bob Phillips

Here is one brute force method

=AVERAGE(SUM(D1:D100,-INDEX(D1:D100,MIN(IF(D1:D100<>"",ROW(D1:D100))))),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)
 
Top