| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dsum evaluating only the beginning of a string?
Hi,
I have notice something strange with the Dsum function it is not comparing the full criteria but only the begining of it for example: name grade a 1 b 2 c 3 d 4 abcd 5 criteria name grade a dsum will give 6 (1 for "a "+ 5 for "abcd") and not the expect 1 for "a" only is there a way around that? Many thanks Dan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dsum evaluating only the beginning of a string?
Use SUMIF function instead of DSUM
=SUMIF(A2:A6,"a",B2:B6) "Dan" wrote: Hi, I have notice something strange with the Dsum function it is not comparing the full criteria but only the begining of it for example: name grade a 1 b 2 c 3 d 4 abcd 5 criteria name grade a dsum will give 6 (1 for "a "+ 5 for "abcd") and not the expect 1 for "a" only is there a way around that? Many thanks Dan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dsum evaluating only the beginning of a string?
Check your other post, too.
Dan wrote: Hi, I have notice something strange with the Dsum function it is not comparing the full criteria but only the begining of it for example: name grade a 1 b 2 c 3 d 4 abcd 5 criteria name grade a dsum will give 6 (1 for "a "+ 5 for "abcd") and not the expect 1 for "a" only is there a way around that? Many thanks Dan -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Evaluating a range | Excel Discussion (Misc queries) | |||
| Stop Excel from evaluating formulae unless I want it to | Excel Worksheet Functions | |||
| Is there away to add a zero to the beginning of number string? | Excel Worksheet Functions | |||
| Removing numbers from the beginning of a text string | Excel Worksheet Functions | |||
| Evaluating similarity of text strings | Excel Worksheet Functions | |||
Hybrid Mode
