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

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