Counting Alpha entries

I

Ian Bendall

I use an Excel spreadsheet to track and add up time used on various
activities, one sheet pet group, I can add up the number stuff OK but
I need to count the number of occurances of type of transaction eg
Meeting = MET and Telephone conversation + TEL, to produce an itemised
summary, I need to know how many meetings or Tel Conversations etc,
the list of codes, 12 in all can sometimes be hundreds long but they
are all in one column, so I need 12 boxes to say how many of each type
of code.
Thanks in anticipation
 
J

JLatham

Look at the COUNTIF() function. Example
=COUNTIF(A2:A500,"MET") or =COUNTIF(A2:A500,"=MET")
 
E

Eduardo

Hi,
suppose that your list is in column A and the 12 codes are in column B
starting cell B2 in C2 enter

=SUMPRODUCT(--(B2=$A$1:$A$1000))

change the range to fit your needs
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top