Average of last n number of cells NOT including blank cells

Hi,

I was wondering if someone knew a function that would be able to calculate the average of the last n number of cells (not including blank cells) in a column. The column would be growing on a daily basis and I would like a function that would automatically account for this so that nothing had to be changed manually. Also, as I've indicated, that column will contain blank cells. I would NOT want these cells being incorporated into the average calcuation. In my example, column A has a set of numbers and blanks. the average of the last three numeric cells is 96. Is it possible to get an equation that could do this and also adjust for data being added to the column. thanks.

Dan

Are you saying that you want to get the "last" value before the blank cell, and the 'n' values before the next blank cell and average them? In other words, continue from your example (see below)

row11 - 90
row12 - blank
row13 - blank
row14 - 10
row15 - 10
row16 - 10
row17 - blank
row18 - blank
row19 - 10

that means, the average will be 30 {(90+10+10+10) / 4}

the array formula worked perfect! Thanks!!