How to call out a worksheet by text in a cell
Posted by Brad on June 26, 2001 11:24 AM
I am trying to make a formula that will do a sumif on a certain range of cells. I want the range it sums to change with the text entered in cell B3. For example I have to sheets called "AA" and "BB". Instead of having "=sumif('AA'!B1:B5, 3, 'AA'!C1:C5)" I want it to key the worksheet off of whatever is in cell B3 of the sheet called "CC" (the sheet where the formula is written). So something like "=sumif('"=b3"'!B1:B5, 3, '"=b3"'!C1:C5)" so if I enter "AA" into B3 it will sum the data on sheet "AA". The formula I proposed doesn't work though. Any thoughts?