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.
Bookmarks