# SumIf with Big Table

**URL:** <https://community.glideapps.com/t/sumif-with-big-table/62376>\
**Category:** Ask for Help\
**Created:** [June 2, 2023, 8:54am UTC](https://community.glideapps.com/t/sumif-with-big-table/62376 "2023-06-02T08:54:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Flowcode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/flowcode/32/64316_2.png) [@Flowcode](https://community.glideapps.com/u/Flowcode)\
**Post date:** [June 2, 2023, 8:54am UTC](https://community.glideapps.com/t/sumif-with-big-table/62376/1 "2023-06-02T08:54:45Z")

</div>

Hi there!

With a regular table, you can do a SumIf by creating a relation with a regular table and then doing a rollup against that relation.

With Big Tables, rollups against relations with a big table aren’t possible. Is there any other way to create a SumIf against a Big Table?

(For example I have one Big Table ‘completions’ with all tasks a user has completed, the ‘completion’ table contains a column that links to the emailadres of the user who created the ‘completion’), I now want to add a column in the user table which counts the number of completions he has but that seems impossible (with a normal ‘Completion’ Table I would create a relation column and then a rollup column against that relation column.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [June 2, 2023, 9:02am UTC](https://community.glideapps.com/t/sumif-with-big-table/62376/2 "2023-06-02T09:02:13Z")

</div>

Have you tried a Query column in the Big Table (which is a multiple-match relation) followed by a Rollup though that Query of the attribute/column you wish to sum?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 2, 2023, 9:08am UTC](https://community.glideapps.com/t/sumif-with-big-table/62376/3 "2023-06-02T09:08:09Z")

</div>

As @nathanaelb suggests, a Query will work for this use case. A relation + rollup would also work, as long as the target column of the relation in the Big Table is not a computed column.

In terms of performance, there is no difference between a relation and query in this case, so I would recommend a query.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [June 3, 2023, 9:08am UTC](https://community.glideapps.com/t/sumif-with-big-table/62376/4 "2023-06-03T09:08:31Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.