Big Leeroy
New Member
- Joined
- Oct 14, 2006
- Messages
- 6
Hello,
I am having trouble with the DCOUNTA. Im not sure if it is really the solution im looking for. I would like to cound the number of instances a varable occures within a column that has several Key Words within each cell.
EXAMPLE:
I would like the formula to display the total count of the instances of the value located in b1 that occure in the list A2-A5.
Thanks for your help.
I am having trouble with the DCOUNTA. Im not sure if it is really the solution im looking for. I would like to cound the number of instances a varable occures within a column that has several Key Words within each cell.
EXAMPLE:
Code:
A B C
1 Key Words dog 2
2 dog, cat, pig
3 house, farm, grass
4 dog, pig, farm
5 tree, flour, dirt
I would like the formula to display the total count of the instances of the value located in b1 that occure in the list A2-A5.
Thanks for your help.