| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula to sum LAST five (5) values in column
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| *** Urgent help formula * Need to sum values in a column if all .. | Excel Worksheet Functions | |||
| I want to copy a column of values, NOT the formula | Excel Discussion (Misc queries) | |||
| AFTER REPLACING FORMULA WITH VALUES, HOW DO I ADD THE COLUMN? | Excel Discussion (Misc queries) | |||
| Move column values w/o formula | Excel Worksheet Functions | |||
| formula to sum LAST five (5) values in column | Excel Programming | |||
Threaded Mode
