DSUM and DCount when criteria values are similar
 

Office 2003 Pro, XP Pro

I have a workbook listing customer groups I am trying to total on.

The field I am isolating on has values that include "VENDOR", "VENDOR SAN
FRANCISCO", and "VENDOR NEW YORK", among others. The DCOUNT AND DSUM are
combining all the VENDOR "Subgroups" into the "VENDOR" group when it
shouldn't be. Other than for the fact the group names begins with "VENDOR"
these should be 3 distinct groups with unique counts and totals.

The results are correct for "VENDOR SAN FRANCISCO" and "VENDOR NEW YORK",
but "VENDOR" sums/counts all 3 together..

How do I fix this (other than adding together the two "right" groups and
subtracting from the "wrong" group)?

Thank you for your help..

BAC


When I use the DSUM and DCOUNT functions

Try:

="=Vendor"

instead of just

Vendor


BAC wrote:
Office 2003 Pro, XP Pro

I have a workbook listing customer groups I am trying to total on.

The field I am isolating on has values that include "VENDOR", "VENDOR SAN
FRANCISCO", and "VENDOR NEW YORK", among others. The DCOUNT AND DSUM are
combining all the VENDOR "Subgroups" into the "VENDOR" group when it
shouldn't be. Other than for the fact the group names begins with "VENDOR"
these should be 3 distinct groups with unique counts and totals.

The results are correct for "VENDOR SAN FRANCISCO" and "VENDOR NEW YORK",
but "VENDOR" sums/counts all 3 together..

How do I fix this (other than adding together the two "right" groups and
subtracting from the "wrong" group)?

Thank you for your help..

BAC


When I use the DSUM and DCOUNT functions