Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Alpha entries
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Alpha entries
Look at the COUNTIF() function. Example
=COUNTIF(A2:A500,"MET") or =COUNTIF(A2:A500,"=MET") "Ian Bendall" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Alpha entries
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 "Ian Bendall" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting alpha data | Excel Discussion (Misc queries) | |||
Sorting numeric and alpha entries | Excel Discussion (Misc queries) | |||
Counting date entries which are the same | Excel Worksheet Functions | |||
Counting entries | Excel Worksheet Functions | |||
Counting Entries | Excel Worksheet Functions |