Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.programming
|
|||
|
|||
dsum evaluating only the beginning of a string?
Try changing your criteria to a formula:
="=a" or use a different formula: =sumif(a:a,"A",b:b) 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 | |||
Extract from the beginning of a text string | Excel Discussion (Misc queries) | |||
dsum evaluating only the beginning of a string? | 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 | |||
use macro to insert characters at the beginning of a string | Excel Programming |