Counting literals in cells

  • Thread starter Thread starter Joeyej
  • Start date Start date
J

Joeyej

I'm trying to figure a quick way using a macro to count the results of
a survey recorded in an Excel spreadsheet. Each record in the survey
has cells that may contain "Yes", "No", "Maybe", "Sometimes" and
"Occasionally". Is there a macro that can count occurrences of each
literal and report their totals?

Thanks,

Joeyej
 
Hi Joeyei,

In excel you can use the CountIf worksheet function:

=CountIf(A1:A100,"Yes")

If you need to do this in code:

Dim Var As Long

Var = Application.CountIf(Range("A1:A100"), "Yes")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Bordered Cells 5
Excel VBA - counting cells by colors and names to it in two different rows. 0
Complex query problem 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
A way to count cells in a range containing text or formulas 2
Count occurrences of filename in column 5
Excel Count If Formula Question 1
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2

Back
Top