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 |
#2
|
|||
|
|||
StephanieH Wrote: 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 Hi Stephanie Try Using your formula on a blank cell in each worksheet, then do your SUMIF using that cell -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=466260 |
Reply |
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 |