Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum if Worksheet name contains certain data
I know =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255) will get
me the name of a worksheet. Is it possible to base a SUMIF formla on the worksheet name? I'd like to set up something that adds cell B23 for all sheets that contain the numbers 150 in the worksheet name. I've tried the Conditional Sum wizard, but it doesn't recognize the set of worksheets as a valid range |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
URGENT Please... new worksheet with copied formats but no data. | Excel Worksheet Functions |