dget or dsum criteria
 

I have several scenarios when I'd like to retrieve a value presented in one
worksheet based on a matched criteria from a separate worksheet. When using
DSUM or DGET, I find that the only way I can successfully retrieve the data
is to insert rows with the column headings before copying the formulas. I'd
love to be able to copy the formulas down with the insert process. Can't
this be done?

Thanks!

dget or dsum criteria
 

It might be better to get away from d formulas in favor of SUMPRODUCT

=sumproduct((rngA="joe")*(rngB=222)*rngC)

--
Don Guillett
SalesAid Software

"maffei" wrote in message
...
I have several scenarios when I'd like to retrieve a value presented in one
worksheet based on a matched criteria from a separate worksheet. When
using
DSUM or DGET, I find that the only way I can successfully retrieve the
data
is to insert rows with the column headings before copying the formulas.
I'd
love to be able to copy the formulas down with the insert process. Can't
this be done?

Thanks!