You are reading a single comment by @mattty 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.
@mattty
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.[/quote]
Screwed up brackets. Should look like this:
[code]
=SUM(SUMIF(C14:C119,B3,G14:G119),SUMIF(J14:J119, B3,N14:N119))
[/code]
Excel has better explanations for errors than G-Docs if you have access to a copy.