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.
|