Forum Discussion
Offset
When there are different cells containing numerical data how do I get the data from the latest 5 cells? I think it's offset but how to arrange this? The value of the latest 5 cells should be ...
SUM-OFFSET sounds like an option for you. Do you have a sample workbook?
Yes I made an example it is about a sportsteam.
When I fill in the next round of scores the yellow cell should calculate the amount of goals scored in the latest five matches. This has to be the case till all matches are played.
Try this. I presumed the Goals scored = "Con" column. If it's the other column then you can change the criteria.
Almost there, in the MATCH part of the formula there is MATCH: (20;6:6;1)-9
20 is the Look up value, why is this the lookup value?
6:6 is the row
;1 is exact value
-9 =?
Can you explain this so I can adjust it in my own file
Thanks in advance