On Tue, 27 Apr 2004 21:56:03 -0700, "rleonard" wrote:

Ron,
Thanks for help,formula does the job of finding the last 5 golf score totals.

you said:
Also, if there are less than five numeric entries, the above formula will give
an error. If this is a problem, let me know.

How would I handle this problem, as it might occur?

It depends on what you want to do if the problem should occur?

=IF(COUNT(score)<5,"Less than five entries",SUM(TRANSPOSE(INDIRECT(ADDRESS(
LARGE(ISNUMBER(score)*ROW(score),{1,2,3,4,5}),COLU MN(score))))))



Also where can I get more info re *array-entered* formula's? This was first time in writing excell code that I had to use an *array-entered* formula!


I started with Excel HELP and the excel newsgroups. I'm not sure where else it
is written about.


--ron