# Sum up **URL:** \ **Category:** Ask for Help\ **Created:** [March 6, 2024, 2:51pm UTC](https://community.glideapps.com/t/sum-up/71473 "2024-03-06T14:51:26Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![We\_the\_Makers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/we_the_makers/32/69750_2.png) [@We\_the\_Makers](https://community.glideapps.com/u/We_the_Makers)\ **Post date:** [March 6, 2024, 2:51pm UTC](https://community.glideapps.com/t/sum-up/71473/1 "2024-03-06T14:51:27Z")
Hello Gliders, I am asking for your help. In my data table I have a list of transactions from different countries and i want to monitor the threshold related to EU countries as a whole and separated by each EU state. I created a If-\>Then column “EU check” True or false for EU country I created a Query filtering by the “EU check” if EU is true - but i wasn’t able to aggregate the Amount to get the sum I then tried to use the Rollup function with the previous Query’s \> Amount but i can only calculate Count but not Sum. Now I am stuck… can anyone help me to solve this? Thank you very much F ![Screenshot 2024-03-06 at 15.37.39](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/c/9c937212c2617e3a8e36cc6b145c298e7d2e6c22.jpeg) ![Screenshot 2024-03-06 at 15.37.55](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/8/b800f303799404f8cebfe8723cb88025330af312.png) ---
**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:** [March 6, 2024, 2:54pm UTC](https://community.glideapps.com/t/sum-up/71473/2 "2024-03-06T14:54:27Z")
> [@We\_the\_Makers](#): > > I then tried to use the Rollup function with the previous Query’s \> Amount but i can only calculate Count but not Sum. This usually indicates that the source column is not a number type. So that is the first thing to check - make sure the column type of the values you want to sum is a Number type. ---
**Author:** ![We\_the\_Makers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/we_the_makers/32/69750_2.png) [@We\_the\_Makers](https://community.glideapps.com/u/We_the_Makers)\ **Post date:** [March 6, 2024, 3:34pm UTC](https://community.glideapps.com/t/sum-up/71473/3 "2024-03-06T15:34:19Z")
Thanks Darren, this already helped to solve the “sum” issue. I could do now queries and rollup for each EU country - but isn’t there an easier way? And secondly If I add another transaction data sheet - is there a computing way to combine both into one (same data structure) new summary data sheet ? I could only find computing fields for columns. Thank you! ---
**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:** [March 6, 2024, 3:50pm UTC](https://community.glideapps.com/t/sum-up/71473/4 "2024-03-06T15:50:00Z")
> [@We\_the\_Makers](#): > > I could do now queries and rollup for each EU country - but isn’t there an easier way? I’m not exactly clear on how you are doing it now. What I would do is have a separate table that lists the countries in a single column, one in each row. Then add a single query + rollup column to that table. That’s about as simple as you can get, I think. > [@We\_the\_Makers](#): > > And secondly If I add another transaction data sheet - is there a computing way to combine both into one (same data structure) new summary data sheet ? I could only find computing fields for columns. I would advise against that. Creating separate tables that hold essentially the same data is a bad idea with Glide (or any database for that matter), and will always come back and bite you eventually. Keep it all in a single table, it will be much easier to work with.