The Value of the kCal is calculated per line using values from other sheets. [totaal kcal] [berekening kcal]

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.

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?

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

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

then you have to create relations to these numbers and rollup-sum these relations [image] How to sum up different amounts for each item? Ask for Help you need to relate items to sold items, then use the rollup column to sum that relation [Screen Shot 2021-12-21 at 6.22.4…

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

How do you calculate the sum of such virtual values?

Ask for Help

Uzo December 27, 2021, 6:50pm 7

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

Topic		Replies	Views
Sum Values for each Row Using Rollup Ask for Help	15	3538	October 3, 2020
Sum a column Ask for Help	9	2449	October 14, 2020
Rollup sum from If, then, else source column Ask for Help	7	1169	July 24, 2020
How to a SUM for each specific row and not the entire column? Ask for Help	4	846	April 18, 2020
Sum lookup values? Ask for Help	9	2554	March 21, 2024

How do you calculate the sum of such virtual values?

Related topics