How do you calculate the sum of such virtual values?

Ask for Help
1

The Value of the kCal is calculated per line using values ​​from other sheets.

totaal kcal
totaal kcal948×560 159 KB

berekening kcal
berekening kcal487×602 36.1 KB

2

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?

3

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.

2 Likes
4

nieuw
nieuw757×433 69.3 KB

if 123 nummer =1 all the values of Ber. kCal must be added.

1 Like
5

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

1 Like
6

for many

7

then you have to create relations to these numbers and rollup-sum these relations

1 Like
8

This is exactly what I meant. I can now continue. Until the next problem reveals itself.

Thanks Uzo.

9

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