Hi, hope the question isn't too difficult, but I have spreadsheet in which
one column captures a contact origin location from an inquiry. For example,
an inquiry can come from one of four sources:

ACC (Accounting)
APR (Purchasing)
ASA (Student Affairs)
AOH (Other)

There can be any number of these in the column. Is there a easy process
that would count the seperate entries of each of the four possibilities and
caculate a sum for each of the four in which then a chart could be generated
depicting the pertage of the whole? (i.e 100 entiries 25, 35, 25, 15 are the
sums respectively then a chart that builds off the percentages? (25% ACC, 35
% APR, 25% ASA, 15% AOH)?

Hope this is clear. Thanks much for you all your help and suggestions.