How do I describe the current worksheet?
I want to add the sum of cell D20 in all worksheets from the first up to the
current. I have tried:
=SUM(Sheet1:MID(CELL("filename",B2),FIND("]",CELL("filename",B2))+1,256)!D20)
but I get an error.
Putting =MID(CELL("filename",B2),FIND("]",CELL("filename",B2))+1,256) into a
separate cell returns the current workspace name, but it doesn't work in the
formula.
Any of you experts have any ideas?
Martin Harriss
Cambridge UK
--
Computer Graphics - CAD Specialist - Internet Information Design
Cambridge United Kingdom
|