Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding up number of yes, no, maybes in a column
Is there a quick and easy way to do add up the number of times a text string
is entered in a column? For example: Column A: Yes Yes Maybe Maybe No Yes No No No Yes How can I get excel to tell me how many "Yes", "Maybe" and "No" there are in column A? This would save me a lot of time! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding up number of yes, no, maybes in a column
Try this:
=COUNTIF(A1:A100,"Yes") Is that something you can work with? *********** Regards, Ron XL2002, WinXP "JRD" wrote: Is there a quick and easy way to do add up the number of times a text string is entered in a column? For example: Column A: Yes Yes Maybe Maybe No Yes No No No Yes How can I get excel to tell me how many "Yes", "Maybe" and "No" there are in column A? This would save me a lot of time! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding up number of yes, no, maybes in a column
Perfect, many thanks!!
"Ron Coderre" wrote: Try this: =COUNTIF(A1:A100,"Yes") Is that something you can work with? *********** Regards, Ron XL2002, WinXP "JRD" wrote: Is there a quick and easy way to do add up the number of times a text string is entered in a column? For example: Column A: Yes Yes Maybe Maybe No Yes No No No Yes How can I get excel to tell me how many "Yes", "Maybe" and "No" there are in column A? This would save me a lot of time! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Column and removing highest number | Excel Discussion (Misc queries) | |||
SEeing if a number in one column is in another column | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions |