Cell A1 = "Red"
Cell A2 = "Green, Red"

When I use DCOUNTA to determine the number of "Red" occurrences, the result
is 1 (rather than 2). Can someone explain why this happens (and a solution
for obtaining the correct count)? Thanks for the help.