counting in excel

[dave_z]

Hi,

I want to create a list of words in a column and in the next column the number of times this word is typed. So, when I type a word in an input cell, the counter of the corresponding word in the list adds 1.

Abba 2
Beatles 1
Scorpions 3

and if I type in my input cell Beatles, the counter should pass from 1 to 2, then when I re-type in the same input cell Scorpions, its counter passes from 3 to 4, and so on. Can anyone help me please? Thanks.

 

[Mike Blackman]

Hi Dave and welcome to the board,

Maybe something like;

=COUNTIF(A:F,"Beatles")

Ensure that the formula does not sit within the range you are searching or you will get a Circular Reference Error!

Hope this helps.