Sum multiple wildcard worksheets

[kinglevel]

Hello

 

Is it possible to reference multiple worksheets with a wildcard and sum it?

 

Bad Example..

=sum(Worksheets_*:A1)

[michaelk]

That is such a great question.  

 

It won't work that way.  But is there a way?  That will take some thought.

[kinglevel]

it would be an ideal way of working when having lots of sublists that one wants to sum up automagically and easily.

[MullinRJ]

I believe it could be done with a worksheet script. Build a Resource List of all worksheets in your drawing; step through each list element and filter the names to match your criteria; if a WS passes the filter, extract the value from cell A1 and sum it; return the sum from your function.

 

What say ye, @michaelk?

 

Raymond