Taking words and creating a value

I am building a lead sheet to track where my company's radio advertisement leads are coming from. I want this sheet to automatically calculate how many leads come from each radio station.

For example, if I have stations "abcd", "efgh", "ijkl", "mnop" and "qrst" I want to add up at the end of the month how many leads came from each station.

Is there a formula that will count instances of a certain word (or in this case, call letters)? If not, is there another way to arrange this that would still provide me the data I am looking for?

Thanks for your help.

fednick,

Try,

=COUNTIF(A2:E20,I1)

Where your leads are in A2:E20 and your call letters are in I1.


HTH

Steve

I'm not sure that will work (it returned "0").

I think I would have to have a separate formula for each individual set of call letters.

If I use the given formula, I don't think it would know how to differentiate from one set of call letters to the next.

I basically have about 5-6 different stations that I need to idenify separate month-end values for.

Of course, I may be misunderstanding the formula.

fednick,

Put your individidual call letters in I1:M1 (if you have more extend). Then put the formula in I2 and copy accross to M2. Formula should be:

=COUNTIF($A$1:$E$20,I1)

As you copy across you will see that the I1 changes to J1,K1,L1,M1 respectively. That will provide a count for each different group of call letters.


HTH

Steve

Thanks for your help. It works perfectly.

fednick,

Glad to hear it worked for you. Thanks for the feedback.

Cheers,

Steve