I am wanting to count up the number of instances of a particular word in a column. I want to then add together two other cells and divide that number by the number of instances of the particular word found in that column.
For example....... =((A1+A2)/[number of times the word "Blue" is found in cells B1:B10])

Hope that makes sense!
Thanks