| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating data in a column
the spreadsheet i am working on has 1 column with 2 possible answers, i.e.
yes/no. what i need to do is separate the replies and then total the yes replies in another cell and also total no replies in a different cell. How do i do it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separating data in a column
The following COUNTIF function can be used
=COUNTIF($A$1:$A$21,"yes") The sort or data filter command can be used to separate the replies. "Gemgirl" wrote: the spreadsheet i am working on has 1 column with 2 possible answers, i.e. yes/no. what i need to do is separate the replies and then total the yes replies in another cell and also total no replies in a different cell. How do i do it? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separating data in a column
Hi,
if you want to see only the yes you can filter the column, th have the total by yes or no, enter in a cell Yes, let's say in C1 and in C2 enter No, then in D1 assuming that the yes or no are in column B starting in B2 enter =COUNTIF(B2:B5000,"Yes") in D2 to count the No enter =COUNTIF(B2:B5000,"No") "Gemgirl" wrote: the spreadsheet i am working on has 1 column with 2 possible answers, i.e. yes/no. what i need to do is separate the replies and then total the yes replies in another cell and also total no replies in a different cell. How do i do it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separating amount in a different column | Excel Discussion (Misc queries) | |||
| Separating a column containing a first and last name... | Excel Discussion (Misc queries) | |||
| Separating text and data in a column | Excel Worksheet Functions | |||
| Separating Names in a Column to Two Columns | Excel Discussion (Misc queries) | |||
| Separating data ( 1 time range) in one column | Excel Worksheet Functions | |||
Linear Mode
