Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP!!! Text count?
Here is my dilemma...
I have a list of phone numbers in excel. Next to each phone number, in the next column, I enter a code for what happened with that call. For example, no answer = na. I want excel to count each na and all of my other codes for me (in a given selection) and tallie those in an organized fashion. Is this even possible...if so, how?! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP!!! Text count?
List your codes once on another sheet, so they might look like this:
ni na out cb am Suppose these are in column A of Sheet2, and your main data is in Sheet1. Assume the corresponding codes are in column C of Sheet1. Put this formula in B1of Sheet2: =COUNTIF(Sheet1C:C,A1) and copy this down, to give you a count against each of those codes. Hope this helps. Pete "Briana" wrote in message ... Here is my dilemma... I have a list of phone numbers in excel. Next to each phone number, in the next column, I enter a code for what happened with that call. For example, no answer = na. I want excel to count each na and all of my other codes for me (in a given selection) and tallie those in an organized fashion. Is this even possible...if so, how?! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
how do i count text and display it as text plus the # times it hap | New Users to Excel | |||
how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |