On 2002-04-19 13:30, daleyman wrote:
is this a question?
if so, then a simple formula in B5 as follows...
=AVERAGE(A1:A5)
...will give you the value you want, and then you can copy and paste this cell every 5 cells. If you want a formula that you can fill down the whole list to give the relevant average every 5 cells, use the following in cell B5 and fill down from there...
=IF(ROUND((CELL("row",A5)/5),0)=(CELL("row",A5)/5),AVERAGE(A1:A5),"")
Hi daleyman:
Why not use your earlier simpler formula
=AVERAGE(A1:A5)
highlite cells A1:A5 and then drag down ... just curious about the merits of using the other long formula you suggested.
Regards!
Yogi Anand
I for one prefer to have a uniform formula in a given column. That way after row insertions/deletions one can easily fill down the formula from the top row without having to worry about which rows should contain the formula. Also, it makes it easier to use the Edit | Go To... Special Column Differences command to detect inconsistencies among the formulas of a given column.