-
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-
Thanks for the reply. I appreciate it. I'll go through it properly this evening.
As a starting point I was just trying to replicate one of the formulas in the guide I posted.
My understanding from other videos is the OFFSET is to deal with the scenario where you have labeled headings so the formula can't SUM the first two as the first field it's adding is no longer has a cell name (like B1).
The teams must be in the same order.
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.