Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Data
Resolved · Low Priority · Version Standard
Reply 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?
For upcoming training course dates see: Pricing & availability
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
|