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 |
All times are GMT +1. The time now is 01:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com