Specific 'count' within spreadsheet

  • Thread starter Thread starter Robert Hayne
  • Start date Start date
R

Robert Hayne

I am putting survey results on a spreadsheet. There are 3
columns (1st, 2nd and 3rd preference) from the survey.
For instance, a student picks choices 5, 8, 64 as his/her
top 3 picks. Let's say they have to pick their top 3
choices out of 75 possible.

There will be about 2000 students (rows). I would like to
have preset 'count' fields that give me on-going number
of "how many 3's", how many 63's, how many 17's, etc.

In other words, on on-going count of how many of each
number have been entered, in only those 3 columns. I need
to get an idea of the numbers BEFORE I finish all the
input.

How can I do this? Thanks, Robert
 
Robert
You can create a table on the side say in column G. Enter 1 through 75 in G1 through G75. Then in H1 enter
=COUNTIF(B:D,G1

and copy down to H75. Now the numbers will update as you add data

If you want to put the table on a seperate sheet use something like
=COUNTIF(Sheet1!B:D,A1

and enter 1 thru 75 in A1 to A7

Good Luck
Mark Graesse
(e-mail address removed)

----- Robert Hayne wrote: ----

I am putting survey results on a spreadsheet. There are 3
columns (1st, 2nd and 3rd preference) from the survey.
For instance, a student picks choices 5, 8, 64 as his/her
top 3 picks. Let's say they have to pick their top 3
choices out of 75 possible

There will be about 2000 students (rows). I would like to
have preset 'count' fields that give me on-going number
of "how many 3's", how many 63's, how many 17's, etc.

In other words, on on-going count of how many of each
number have been entered, in only those 3 columns. I need
to get an idea of the numbers BEFORE I finish all the
input

How can I do this? Thanks, Rober
 
Back
Top