C14:C119 and J14:119 = a team name. There will be 8 instances of this team name. G14:119 and N14:N119 are values (points, goals, goals scored, etc.). I want them added up.
I've used this formula before (last years polo league spreadsheet). It worked fine. Now, it works once, in one row. As soon as I add more instances (below) of the formula, it updates that row, but makes the one above fail.
Google spreadsheets. Why is this:
giving me a circular dependency error?
C14:C119 and J14:119 = a team name. There will be 8 instances of this team name. G14:119 and N14:N119 are values (points, goals, goals scored, etc.). I want them added up.
I've used this formula before (last years polo league spreadsheet). It worked fine. Now, it works once, in one row. As soon as I add more instances (below) of the formula, it updates that row, but makes the one above fail.