Well,

imagine a stack of spreadsheets with names product1, product2, etc. On
top of those is a spreadsheet with name, say, "production unit."

Some cells in the latter show sums of the underlying cells from
"product" sheets, not necessarily all of them, but according to what is
included in wslist.

This is what the formula I mentioned previously does for the cell A1.
Since it is somewhat long and in fact contains only one parameter, viz.,
the cell name, I sought perhaps there is a way to specify a function
with a single argument that takes a cell address and returns the result
computed by the formula. In regular programming language: C, C++, Java,
Fortran, Pascal, perl, you name it ... this is a trivial matter. I found
no indication in the Excel's help it allows to do such a simple thing.
Since I am doing that for a client who might be prone to mistype the
formula, an abbreviation would be appreciated. Having to copy and paste
is the next best thing. So I very much appreciate the reply I received
on another group. Still, is it possible to define such a function in
Excel?

Thank you for your interest.

Alexander Bogomolny

Bigwheel wrote:

Could you say what it is you are trying to achieve? What values are
involved and in what cells?