View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dh13134 dh13134 is offline
external usenet poster
 
Posts: 20
Default "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