Average the total of 3 columns
 

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.
--
cruchnin numbers

Average the total of 3 columns
 

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)



"belvy123" wrote in message
...
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.
--
cruchnin numbers