D
dh13134
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
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