Prev: Unhide multiple worksheets in workbook
Next: Inserting sheets into Excel workbook
From: Gemgirl on 27 Jan 2010 12:21
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?
From: Vivek on 27 Jan 2010 12:36
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?
From: Eduardo on 27 Jan 2010 12:40
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?
 | 
Pages: 1
Prev: Unhide multiple worksheets in workbook
Next: Inserting sheets into Excel workbook