link workbook range

[ratman]

I need to have this formula

=AVERAGE(IF(rngDate>=rngFromDate,IF(rngDate<=rngToDate,
IF(rngAcct=rngAcctCriteria,rngAmt))))

reference the rng of another workbook. rng's Date, Acct and Amt are the rng's that will be remote.
rng's ToDate FromDate and AcctCriteria are local.

Thanks,
Dave Rattigan alias ratman

 

[ratman]

I figured it out

I used the Insert/Names/Define option and was able to name the rng's......cool