Wed 13 Feb 2008, 16:28Delegate Olivia said...
Olivia has attended:
Excel Introduction course
Data
How do you 'count' words in a spreadsheet? ie. if a column was made up of yes's and no's, and I wanted to record how many of each there were eg. NO 24 YES 47 how would I do that?
Fri 15 Feb 2008, 15:49Trainer Stephen said...
RE: Data
Hello Olivia
Thank you for your question.
You need to use the countif function. Countif simply looks at a specified range of cells and counts the cells whose contents meet a specified criteria
The syntax for your problem would be
=COUNTIF(C1:C5,"yes")
where C1:C5 is the range of cells to be searched and "yes" is the criteria to be counted
You would then repeat this process with the criteria "no" in another cell
Hope this is useful
Regrds
Stephen
