Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula to sum LAST five (5) values in column
TRY =ROUND((SUM(B3:B10)) / COUNT(B3:B10),0) Date Score 2 5/12/04 50 3 5/15/04 49 4 5/20/04 Did not Play 5 5/29/04 50 6 6/01/04 45 7 6/05/04 50 8 6/10/04 Did not Play 9 6/20/04 49 COUNT 6 COUNT(B3:B10) TOTAL 293 SUM(B3:B10) 49 ROUND((SUM(B3:B10)) / COUNT(B3:B10),0) "rleonard" wrote in message ... I am trying to develop a formula that will sum last 5 values entered in a column of numbers. The values are golf scores which i need to total so i can come up with an average based on last 5 games. problem is that a person may not have a score for every date, for example: Row a b 1 Date score 2 5/12/04 50 3 5/15/04 49 4 5/20/04 Did not play 5 5/29/04 50 6 6/01/04 45 7 6/05/04 50 8 6/10/04 Did not play 9 6/20/04 49 count(A2:A9)=6 Sum(A2:A9)=293 i need a formula that wii sum just the last 5 scores, which in this case would be 243. Thanks for any help! Bob Leonard |
Reply |
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 | |||
Searching for Data Values in a Column - Formula Only | Excel Programming |