I have the names of dealers along with the associated data located in various tabs in a particular workbook. I wrote a sumif formula for one and included the names of the dealers in the cell to the left... I want to change my formula so that when I drag it down it takes the names of the dealers (from the row of cells to the left of the formula) and use it to populate the workbook references in the sumif formula.
Is what I start with, I change the references to:
but then I'm prompted for the location of the workbook containing worksheet F3... I also tried enclosing "F3" in quotes to no avail.
Is it possible to make a formula like this work?