# Rollup sum from If, then, else source column **URL:** \ **Category:** Ask for Help\ **Created:** [June 18, 2020, 6:51pm UTC](https://community.glideapps.com/t/rollup-sum-from-if-then-else-source-column/11093 "2020-06-18T18:51:33Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Ed\_V](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed_v/32/2667_2.png) [@Ed\_V](https://community.glideapps.com/u/Ed_V)\ **Post date:** [June 18, 2020, 6:51pm UTC](https://community.glideapps.com/t/rollup-sum-from-if-then-else-source-column/11093/1 "2020-06-18T18:51:33Z")
Hey Gliders, Just a quick one: I’m trying to sum the values from a multiple relation column using the rollup function however I can only see count and count unique, not a sum option. I assume this is because the source column in the multiple relations in a if, then, else format rather than a number number format. Is there a away around this? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c3011961d7c6965a400b5948d9ab9c7791fd18ba.png) Cheers, Ed ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 18, 2020, 7:29pm UTC](https://community.glideapps.com/t/rollup-sum-from-if-then-else-source-column/11093/2 "2020-06-18T19:29:56Z")
Can you try creating a template column in the sheet you are relating to and fill it with the result from the if then column? Then try to use the rollup against the template column. I’m not sure if it will work, but I’ve had success with other things by moving the value to a template column. ---
**Author:** ![Ed\_V](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed_v/32/2667_2.png) [@Ed\_V](https://community.glideapps.com/u/Ed_V)\ **Post date:** [June 18, 2020, 8:15pm UTC](https://community.glideapps.com/t/rollup-sum-from-if-then-else-source-column/11093/3 "2020-06-18T20:15:46Z")
Thanks for the suggestion Jeff. Unfortunately this didn’t work. Tried the same with a math formula as well ☹ ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 19, 2020, 1:00am UTC](https://community.glideapps.com/t/rollup-sum-from-if-then-else-source-column/11093/4 "2020-06-19T01:00:19Z")
Wild idea, but can you try a math column and multiply everything by 1? ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [June 19, 2020, 8:33am UTC](https://community.glideapps.com/t/rollup-sum-from-if-then-else-source-column/11093/5 "2020-06-19T08:33:37Z")
Or just replacing the same column but in a new Math one ---
**Author:** ![Ed\_V](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed_v/32/2667_2.png) [@Ed\_V](https://community.glideapps.com/u/Ed_V)\ **Post date:** [June 19, 2020, 8:15pm UTC](https://community.glideapps.com/t/rollup-sum-from-if-then-else-source-column/11093/6 "2020-06-19T20:15:46Z")
Someone give this Glider a medal! Works perfectly - thanks Thinh! 🙂 ---
**Author:** ![thinker\_creative](https://avatars.discourse-cdn.com/v4/letter/t/c57346/32.png) [@thinker\_creative](https://community.glideapps.com/u/thinker_creative)\ **Post date:** [July 24, 2020, 5:43pm UTC](https://community.glideapps.com/t/rollup-sum-from-if-then-else-source-column/11093/7 "2020-07-24T17:43:16Z")
I would also like to see this working. Rollup does not recognize numbers in If-\>Else columns as numbers ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 24, 2020, 10:09pm UTC](https://community.glideapps.com/t/rollup-sum-from-if-then-else-source-column/11093/8 "2020-07-24T22:09:35Z")
Can you try the Math column approach above? We don’t have it happen naturally as of now so that’s a workaround. ---
**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:** [January 23, 2024, 3:18pm UTC](https://community.glideapps.com/t/rollup-sum-from-if-then-else-source-column/11093/9 "2024-01-23T15:18:16Z")