Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data
Resolved · Low Priority · Version Standard
Olivia has attended:
Excel Introduction course
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?
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
|
Excel tip:How to Remove Duplication's from a selection of data in an Excel 2010 WorksheetIt would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:- |
We'll call during UK business hours
Server loaded in 0.09 secs.