Counting Entries

**snelsonian** · 09-10-2009, 07:21 PM

Hi all,

I have a spreadsheet with thousands of answers from a questionnaire. In each column, I have the answers to one question where the answers could be Yes, No, or Don't Know. How do I count the total number of 'No's, for example, in one column?

I know how to sort by column and then select the entries I'm looking for, but there has to be a better way.

Any help appreciated - VBA code or otherwise!

Thanks in advance.

**stanleydgromjr** · 09-10-2009, 07:36 PM

snelsonian,

If your column for "No" is column A, try in cell B1:
=COUNTIF(A:A,"=No")

**daddylonglegs** · 09-10-2009, 07:36 PM

You can use COUNTIF function e.g. use this formula to count "No"s in column A

=COUNTIF(A:A,"No")

**Palmetto** · 09-10-2009, 09:00 PM

If you have a large dataset and many types of responses to quantify, take a look at using a Pivot Table.

**snelsonian** · 09-10-2009, 10:40 PM

All great suggestions - the countif function works like a champ, but the Pivot Table is exactly the kind of automation I was looking for. I learn something new every day.

Thanks again!