I am using Excel XP in Window XP, and am having trouble creating a formula in a workbook with many worksheets (my test book only has a few, but could be potentially 150-200 sheets). Each of these sheets is based on a template, so that the "total" cells are all the same. I am trying to create a formula in a summary worksheet, summing the same cell in all worksheets with a particular text in cell B2. This text refers to a status, and there are five possible phrases.
The only formula I can get to work only refers to one sheet: =IF('worksheet'!B2="Submitted", +'worksheet'!D21,"+0")
I get #VALUE for the following formula: =SUMIF('worksheet1:worksheet5'!B2,"Submitted",'worksheet1:worksheet5'!D21)
I get FALSE for this formula: =IF(worksheet1!B2="Submitted",+worksheet!D21," "),=IF(worksheet2!B2="Submitted",+worksheet2!D21," " etc.
Can anyone help? Paula
The only formula I can get to work only refers to one sheet: =IF('worksheet'!B2="Submitted", +'worksheet'!D21,"+0")
I get #VALUE for the following formula: =SUMIF('worksheet1:worksheet5'!B2,"Submitted",'worksheet1:worksheet5'!D21)
I get FALSE for this formula: =IF(worksheet1!B2="Submitted",+worksheet!D21," "),=IF(worksheet2!B2="Submitted",+worksheet2!D21," " etc.
Can anyone help? Paula