Sum if Worksheet name contains certain data

[Guest]

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

 

[Paul Sheppard]

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 o
the
worksheet name? I'd like to set up something that adds cell B23 fo
all
sheets that contain the numbers 150 in the worksheet name.

I've tried the Conditional Sum wizard, but it doesn't recognize the se
of
worksheets as a valid range

Hi Stephanie

Try Using your formula on a blank cell in each worksheet, then do you
SUMIF using that cel