# How do you calculate the sum of such virtual values? **URL:** \ **Category:** Ask for Help\ **Created:** [December 27, 2021, 5:30pm UTC](https://community.glideapps.com/t/how-do-you-calculate-the-sum-of-such-virtual-values/36391 "2021-12-27T17:30:10Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Hans\_Op\_het\_Roodt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans_op_het_roodt/32/36370_2.png) [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)\ **Post date:** [December 27, 2021, 5:30pm UTC](https://community.glideapps.com/t/how-do-you-calculate-the-sum-of-such-virtual-values/36391/1 "2021-12-27T17:30:10Z")
The Value of the kCal is calculated per line using values ​​from other sheets. ![totaal kcal](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/ebaca497b85d6ab2384e9dd97beaf1998fe97e9d.jpeg) ![berekening kcal](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5c9a90c65ea3b893196eed56f01b48b9a5ae4af5.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 27, 2021, 5:45pm UTC](https://community.glideapps.com/t/how-do-you-calculate-the-sum-of-such-virtual-values/36391/2 "2021-12-27T17:45:23Z")
you forgot to ask questions or point the problem… so I assume the title is the question and you need to sum Ber. kcal column… so, add a roll-up column and sum that one, and I have no idea what you mean by “if number is equal”… to what value? ---
**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:** [December 27, 2021, 5:55pm UTC](https://community.glideapps.com/t/how-do-you-calculate-the-sum-of-such-virtual-values/36391/3 "2021-12-27T17:55:20Z")
You can create a multiple relation column linking the nummer column back to itself. This will link each row with a nummer to every other row that has the same nummer. Then you can use a rollup column to sum the column you need through that relation. ---
**Author:** ![Hans\_Op\_het\_Roodt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans_op_het_roodt/32/36370_2.png) [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)\ **Post date:** [December 27, 2021, 6:38pm UTC](https://community.glideapps.com/t/how-do-you-calculate-the-sum-of-such-virtual-values/36391/4 "2021-12-27T18:38:07Z")
![nieuw](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cb088545a389e3d18a8dc779a2e5dd1053e24c5c.png) if **123 nummer** =1 all the values of **Ber. kCal** must be added. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 27, 2021, 6:44pm UTC](https://community.glideapps.com/t/how-do-you-calculate-the-sum-of-such-virtual-values/36391/5 "2021-12-27T18:44:36Z")
it is for many values or just for 1 and 2? if just for 2 values, create IF-ELSE column to get values… IF nummer = 1 then Ber.kcal ELSE 0, and use rollup column to sum it ---
**Author:** ![Hans\_Op\_het\_Roodt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans_op_het_roodt/32/36370_2.png) [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)\ **Post date:** [December 27, 2021, 6:46pm UTC](https://community.glideapps.com/t/how-do-you-calculate-the-sum-of-such-virtual-values/36391/6 "2021-12-27T18:46:43Z")
for many ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 27, 2021, 6:50pm UTC](https://community.glideapps.com/t/how-do-you-calculate-the-sum-of-such-virtual-values/36391/7 "2021-12-27T18:50:09Z")
then you have to create relations to these numbers and rollup-sum these relations > [@How to sum up different amounts for each item?](https://community.glideapps.com/t/how-to-sum-up-different-amounts-for-each-item/36209/2): > > you need to relate items to sold items, then use the rollup column to sum that relation remember… sum relation, not a lookup, I put lookup there just for better understanding what is in the sold sheet… you can also use this technique to count sold items, get average or range … ---
**Author:** ![Hans\_Op\_het\_Roodt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans_op_het_roodt/32/36370_2.png) [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)\ **Post date:** [December 27, 2021, 7:28pm UTC](https://community.glideapps.com/t/how-do-you-calculate-the-sum-of-such-virtual-values/36391/8 "2021-12-27T19:28:30Z")
This is exactly what I meant. I can now continue. Until the next problem reveals itself. Thanks Uzo. ---
**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:** [December 28, 2021, 7:28pm UTC](https://community.glideapps.com/t/how-do-you-calculate-the-sum-of-such-virtual-values/36391/9 "2021-12-28T19:28:31Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.