| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DSum not recognising criteria correctly
I am using Excel 2000 and have the following formula in a cell:
=DSUM(CRData,7,acd) Unfortunately to get the right answer I have to put: =DSUM(CRData,7,acd)-DSUM(CRData,7,acdiv) Why does Excel sum all the €œdiv€ values into the total of €œd€ values so that to get the true €œd€ total uou have to subtract the €œdiv€ (or any other 3 letter group beginning with d). I have tried these formulae in Lotus and there is no problem. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DSum not recognising criteria correctly
The answer to this is that the default is "anything starting with" what is in
the criterion. To get an exact match (as required here) the second line of the criterion needs to be ="=d" which displays as =d. The "right" answer is then obtained. It makes me think about all criteria I have! "Sue" wrote: I am using Excel 2000 and have the following formula in a cell: =DSUM(CRData,7,acd) Unfortunately to get the right answer I have to put: =DSUM(CRData,7,acd)-DSUM(CRData,7,acdiv) Why does Excel sum all the €œdiv€ values into the total of €œd€ values so that to get the true €œd€ total uou have to subtract the €œdiv€ (or any other 3 letter group beginning with d). I have tried these formulae in Lotus and there is no problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DSum criteria | Excel Discussion (Misc queries) | |||
| DSUM criteria | Excel Worksheet Functions | |||
| DSum criteria | Excel Worksheet Functions | |||
| HOW TO USE DSUM WITH MORE THAN ONE CRITERIA | New Users to Excel | |||
| Using DSUM with several criteria | Excel Worksheet Functions | |||
Hybrid Mode
