I have a spreedsheet laid out thus: column A Code B: players name C: price D: team name E: month total F: year total. My question is, someone gave me a lookup formula so I had all players listed alphebetically starting row 69-148 because certain players appear in different teams more than once which is - =VLOOKUP(B3,Scores,2) so i only have to enter the data once and it will put the players score automatically next to there name in ten different teams. So what they score in the month is in column E. What I want is there to be a running total for the year in column F. I know it seems a bit long winded but any help would be appreciated.
Well if you hadn't just added that bit I was going to suggest entering
in Column F and copying down. You would need to change all the "1:5" references to the actual rows that your data occupies. You will gather from the above that I had assumed that the spreadsheet held the scores for each month.
If you reset every month then I cannot see a way of retaining a running total unless every time you "reset" you also store the previous total somewhere.