View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wendy[_7_] Wendy[_7_] is offline
external usenet poster
 
Posts: 1
Default formula- find min value in range, then average that value with one value on each side

Can anyone please help with an excel formula to find the minimum value
in a row range, then average that value with one value on each side?

I was currently using this formula to find the 4 smallest values and
average them together, but now I want to find the smallest and average
consecutive values (one on each side)

=AVERAGE(SMALL('Sheet1'!$C$9:$L$9,{1,2,3,4}))

Hope this makes sense.
Thank you in advance for your help.
Wendy