You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
-
D9 is still wrong, it's £100 too low. I don't really know what your offset formula is doing, not sure why you have the rows part in there which is offsetting it by 1 to the right or why you are picking up b1 as your reference cell rather than the row you want to sum.
I've added in a corrected offset formula and a sumif formula which seems the more obvious way to do it.
Are you also trying to add in a second condition for the team or will it always be in the same order?
aggi
@hugo7
Seriously what is going wrong here?
I'm following this: https://www.exceldemy.com/calculate-ytd-year-to-date-in-excel/
to work out the sum of the y2d for each team.
see eg: https://docs.google.com/spreadsheets/d/1S8I1DwLBInGWNBN9yLSOf9h2rxqyhwjlNJlbmeChKag/edit?usp=sharing
D9 gives the value you'd expect.
But then E9 and F9 give the same value, rather than totaling their respective rows. How come?
I probably need to make proper table headings(?), but ideally I wanted to have all the headings = the headings from another workbook.