Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
is it possible to sum up calculated fields from other worksheets in an external worksheet?
In the present example, this means that for a given number of pieces produced, there are a certain amount of samples. I have assigned the quantity of the sample to each order. Now, on another worksheet, I want to create a year statistic and a month statistic in which I want to sum up the set of samples.
Thanks,
Dominic
Yes , possible . Could you please share the sample data ? so that we could guide you
Unfortunately I can not create a table in the script (because access rights to the data sources are necessary, which I don't have). Therefore I calculate the number of samples with nested if-functions in the "order data" table.
I hope the screenshot will help out.