Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data

Data

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

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Data

Data

RE: Data

Excel articles

Excel tip:

Saving your Excel Spreadsheet as a CSV File