sum up values from different worksheets

[dominicanlauf]

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

[avinashelite]

Yes , possible . Could  you please share the sample data ? so that we could guide you 

[dominicanlauf]

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.