Morning guys,

If I have a colum say i2 to i20, and each cell contains one of three possible data values, is there a way to have a KEY at the side of the sheet to display the volume of each value in each cell.

e.g. colums I1 to I30 are written as :

yes
maybe
no
no
no
maybe
yes
yes
yes
maybe


.. etc.

I want a key to tell me how many YES', No's and Maybe's there are, which will also auto update when I change a value from one value to any of the other two.


Any ideas boys?