View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default how do I get excel to add,then average numbers with two decima

Errata....

I wrote:
For example, for the average of the best of 3, enter the
following as an array formula (ctrl+shift+Enter):
=AVERAGE(LARGE(data,ROW(A1:A3)))
Alternatively, the following regular (non-array) formula does the same thing:
=SUMPRODUCT(LARGE(data,ROW(A1:A3))) / 3


I guess the best of 3 is SMALL(), not LARGE().

Also, "data" should be A1:A5. An artifact of cut-and-pasting from my
worksheet. Note that "ROW(A1:A3)" is simply a way of getting the numbers 1
through 3. It has nothing to do with the data in column A.