| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using DSUM with several criteria | Excel Worksheet Functions | |||
| How can I use DGET in Excel with criteria that changes each line? | Excel Worksheet Functions | |||
| dget or dsum? that is the question | Excel Discussion (Misc queries) | |||
| dget or dsum? that is the question | Excel Discussion (Misc queries) | |||
| how do i get "DGET" to take the first data meeting the criteria? | Excel Worksheet Functions | |||
Hybrid Mode
