| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
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 |
Threaded Mode
