Thread: averages for cells
View Single Post
  #2  
Old September 23rd, 2008, 05:36 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
  
Posts: 1,245
Default averages for cells
jatman wrote:
i have a spreadsheet that calculates averages, but as i add more columns, it
always calculates the same columns:

B F G H I J
ITEM AVG # ## # #

the formula that i am using is =(SUM(G3:O3)-MIN(G3:O3)-MAX(G3:O3))/7 (drops
the lowest and highest and make an olympic average to use).

when i insert another row of the most recent data on the left side (push old
data to the right, but keep the information). i insert a column between f
and g (new column is now g...). the formula changes and continues to use the
same values and not the new values...

formula changes to =sum(h33)-min(h33)-max(h33))/7

how do i get it the formula to limit itself to just the original selection,
even if i insert columns in the selection?

thank you,

jat



=(SUM(INDIRECT("G3:O3"))-MIN(INDIRECT("G3:O3"))-MAX(INDIRECT("G3:O3")))/7