Calculate total by expressions values

[francis_gr]

Hi!

In my attached sample i have a list box where i can select the expressions that i want to show in my chart.

The problem is that Total expression is always the sum of the other 3 expreesions, so i need that Total expression show only the sum of the selected expressions in the list box

Thanks in advance

Regards

[jonathandienst · Accepted solution]

Reference the columns by name:

=Rangesum(sales1, sales2, sales3)

(RangeSum() will correctkt handle the null case when an expression is not selected)

[francis_gr]

Hi Jontydkpi!

It works ok!

Thanks for sharing your knowledge and for your time

regards