R
Robert
I am using the DSum function in a spread sheet to extract
partial information from a data list I created according
to the criteria set forth by me in the DSum formula. The
criteria includes more than one column from the data one
being the column labeled "Option". In my data this column
will have one of the following (A,B,C or C1). The problem
is that when the criteria for "Option" is C the DSum
function cannot differentiate between those lines with C
from those with C1 and adds them all together. However
when the criteria for "Option" is C1 it sums only those
lines with C1 in the "Option" column which is what it
should do. I changed C1 to C 1 to CC with no change in
results when the criteria is C. This appears to be a flaw
in the programming of the DSum function. It would appear
the programming is not looking for an exact match but an
approximate match. Only when C1 was changed to D in my
data list did I get the correct results.
Thanks for any help or comments
Tried to e-mail Microsoft about this but when I click were
it says to go to inform them of product bugs there was no
selection to go the next step
Robert
partial information from a data list I created according
to the criteria set forth by me in the DSum formula. The
criteria includes more than one column from the data one
being the column labeled "Option". In my data this column
will have one of the following (A,B,C or C1). The problem
is that when the criteria for "Option" is C the DSum
function cannot differentiate between those lines with C
from those with C1 and adds them all together. However
when the criteria for "Option" is C1 it sums only those
lines with C1 in the "Option" column which is what it
should do. I changed C1 to C 1 to CC with no change in
results when the criteria is C. This appears to be a flaw
in the programming of the DSum function. It would appear
the programming is not looking for an exact match but an
approximate match. Only when C1 was changed to D in my
data list did I get the correct results.
Thanks for any help or comments
Tried to e-mail Microsoft about this but when I click were
it says to go to inform them of product bugs there was no
selection to go the next step
Robert