Data

Resolved · Low Priority · Version Standard

Wed 13 Feb 2008, 16:28 Delegate 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:49 Trainer 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

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet

It 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:-

1) Select the data that might contain duplication's
2) Click the ''Data'' tab
3) Go to ''Data Tools'' and click ''Remove Duplicates''
4) A box will appear. Tick the boxes of the columns that you want to use to check for duplicates. Finally, click ''OK.''

View all Excel hints and tips

Data

Data

RE: Data

Excel articles

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet