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 |