dget or dsum criteria

G

Guest

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!
 
D

Don Guillett

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using cell reference with logical operator in DGET expression 1
Question using DGET function 1
Dget, sumif vlookup 4
Have DGET return Null instead of #Value! 3
DGET/DSUM etc 2
How can I use DGET in Excel with criteria that changes each line? 4
DGET Function - using a split criteria range? (Excel 2007) 0
DSUM criteria 3

Top