Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Question (that I really can't describe!) | Excel Worksheet Functions | |||
'Save current worksheet'; 'Open next worksheet' - two command buttons | Excel Discussion (Misc queries) | |||
describe introduction to spreadsheets | New Users to Excel | |||
Updating different worksheet with value on current worksheet | Excel Worksheet Functions | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) |