Thread: Separating data in a column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Vivek Vivek is offline
external usenet poster
  
Posts: 22
Default 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?
Reply With QuoteReply With Quote