database problem

  • Thread starter Thread starter Liza
  • Start date Start date
L

Liza

I am a novice try to do a database. I am doing a table
that requires me to constantly put in the number of times
someone answers "yes" "no" or "sometimes" on a survey. I
am looking for a way to set up a table that does not
require me to change the number manually (I will have
approximately 200 answers), but cannot find a formula that
will make a cell continuously increase in value by 1. Is
this possible to set up in Excel, or am I stuck doing all
of this manually? Please help, I have 5 similar surveys
to do!
 
Assume your answers are in Column A. Put these in cells

C2 - Yes
C3 - No
C4 - Sometimes

In D2, put this formula:

=COUNTIF($A:$A,"Yes")

In D3, put this:

=COUNTIF($A:$A,"No")

In D4 put this

=COUNTIF($A:$A,"Sometimes")

Now as the answers are added in clumn A, then formulas will keep trac
of each.
 
Back
Top