"DCOUNTA-ING" too many items...
i have several industry group names in a column - general example:
A5 thru A10 contain "Electronics" (5 total)
A10 thru A15 contains "Electronics Semiconductors" (5 total)
A15 thru A20 contains "Electronics Equipment" (5 total)
when i use the DCOUNTA function with "Electronics" as my criteria, the
result gives me 15 "answers", when i only want 5 - "Electronics". i'm getting
everything that even "contains" "Electronics" instead of only the 5 that i
want.
any thoughts would be appreciated.
i'm using DCOUNTA but my results
--
dh13134
|