Check if values equal each other, then sum other values of that row.

AppSheet AppSheet Q&A
1

I have two Tables, main and form. I want in the form table a row “average” to be the sum of the “grade” divided by the sum of the “weight”, but only when the “subject” rows in the main and form table are the same.

Now i got something like this: SUM(main[grade]) / SUM(main[weight]), but it averages every grade from every subject.

2

This is a list of all values in the “grade” column of the “main” table. Use a function to filter that list only to the values you want. For example:

[SELECT](https://support.google.com/appsheet/table/10104782?hl=en&ref_topic=10099895,10173496,10099316,#query=select()(main[grade], [subject] = [_THISROW].[subject])

Depending on whether and how you have created any References between tables, you might have even more efficient options by leveraging reverse references or Dereference expressions. For example:

SUM([Related mains][grade])
1 Like