View Single Post
  #1   Report Post  
Diederik
 
Posts: n/a
Default Auto average function

In Excel there is an autosum function. When you are in an empty cell below a
range of data this function puts the sum of the range above into the empty
cell.
I was wondering if it is possible to adapt this function so that, instead of
a sum, it calculates a different statistical value like average, number,
stdev?
My idea would be an extra button in the toolbar with auto... which opens a
checkbox menu from which you can choose the statistical function (sum, stdev,
average etc) that should apply to the range.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions