You are reading a single comment by and its replies. Click here to read the full conversation.
  • Google spreadsheets. Why is this:

    =sum(SUMIF(C14:C119,B3,G14:G119)),(SUMIF(J14:J119,B3,N14:N119))

    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.

About

Avatar for   started