Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Reference the columns by name:
=Rangesum(sales1, sales2, sales3)
(RangeSum() will correctkt handle the null case when an expression is not selected)
Reference the columns by name:
=Rangesum(sales1, sales2, sales3)
(RangeSum() will correctkt handle the null case when an expression is not selected)
Hi Jontydkpi!
It works ok!
Thanks for sharing your knowledge and for your time
regards