You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
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.