Sumif and Indirect - Help stuck

loftis01

loftis01

Joined
May 9, 2012
Messages
10
Reaction score
0
I am attempting to write a sumif formula that will utilize the indirect to access a another file name and path.

Cell A11 provides the following information: I:\CASHOPS.SDO\123DATA.FOP\PRELIM12\[PREL0601.xls]

The formula is the following:
=SUMIF(INDIRECT('"&A11"A'!$A$6:$A$23,E7,'"&A11"A'!$C$6:$C$23))

The message states the following: You have entered too many arguments for that function.

Help!:fool:
 
Part of the probelm here is that to add the apostrophe you want to use "'"(Quote Apostrophe Quote). And you're missing an ampersand after the reference to A11. You have most of it right, but you're also missing the end of the first INDIRECT and then the Second INDIRECT formula for the Sum Range. Try this out:

=SUMIF(INDIRECT("'"&A11&"A'!$A$6:$A$23"),E7,INDIRECT("'"&A11&"A'!$C$6:$C$23"))
 
Back
Top