# SUMIF Rollup **URL:** \ **Category:** Ask for Help\ **Created:** [May 2, 2024, 4:34am UTC](https://community.glideapps.com/t/sumif-rollup/73000 "2024-05-02T04:34:33Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![hadassi82](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hadassi82/32/73293_2.png) [@hadassi82](https://community.glideapps.com/u/hadassi82)\ **Post date:** [May 2, 2024, 4:34am UTC](https://community.glideapps.com/t/sumif-rollup/73000/1 "2024-05-02T04:34:34Z")
I would like to sum values from a certain math column based on a common value in a template column I have. Example: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/d/8db9b9fa3c9aa3f37810ccbd36554e34defada93.png) I have endless values in the template column, so I cannot create an IF-THEN-ELSE column for each value I have. What is the easiest way to create this? ---
**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:** [May 2, 2024, 4:40am UTC](https://community.glideapps.com/t/sumif-rollup/73000/2 "2024-05-02T04:40:41Z")
Use a Query column and apply a filter, then do a rollup through the query. ---
**Author:** ![hadassi82](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hadassi82/32/73293_2.png) [@hadassi82](https://community.glideapps.com/u/hadassi82)\ **Post date:** [May 2, 2024, 5:00am UTC](https://community.glideapps.com/t/sumif-rollup/73000/3 "2024-05-02T05:00:41Z")
Can you please elaborate? I am not able to get what I need… ---
**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:** [May 2, 2024, 5:07am UTC](https://community.glideapps.com/t/sumif-rollup/73000/4 "2024-05-02T05:07:10Z")
Well, the Query column negates the need for Template columns in such cases, so you can ignore that. Step by step: - Add a Query column, target it at the same table, and apply the following filters: – First Name is This row-\>First Name – Last Name is This row-\>Last Name - Now add a Rolllup column, target it at the Query column, and select Sum-\>Price. If you don’t see the sum option in the rollup, check and make sure that your Price column is a number type. ---
**Author:** ![hadassi82](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hadassi82/32/73293_2.png) [@hadassi82](https://community.glideapps.com/u/hadassi82)\ **Post date:** [May 2, 2024, 6:10am UTC](https://community.glideapps.com/t/sumif-rollup/73000/5 "2024-05-02T06:10:29Z")
Thank you very much for the explanation, but something does not work… This is what I do: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5aaeb6659fcbd4503e16fe0db12327fc48c4d53d.png) This is what I got for the query: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/39a3698e41496f85761f3a28f7ae4e7dc95e3eb1.png) And as the query returns the name value - I cannot create a rollup based on it: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/5691ead0261c89275366e7e91cde339f23671a76.png) What am I missing here? ---
**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:** [May 2, 2024, 6:55am UTC](https://community.glideapps.com/t/sumif-rollup/73000/6 "2024-05-02T06:55:10Z")
![CleanShot 2024-05-02 at 14.54.18@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ad0955340c2570308fa629dfcd51d4bc4937f7ee.jpeg) ---
**Author:** ![hadassi82](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hadassi82/32/73293_2.png) [@hadassi82](https://community.glideapps.com/u/hadassi82)\ **Post date:** [May 2, 2024, 6:59am UTC](https://community.glideapps.com/t/sumif-rollup/73000/7 "2024-05-02T06:59:17Z")
Perfect! Thank you!! ---
**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:** [May 9, 2024, 7:00am UTC](https://community.glideapps.com/t/sumif-rollup/73000/8 "2024-05-09T07:00:06Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.