Need help with Excel 2007 =countif

I hve a worksheet that records car show votes of varying numbers based on attendance.

I need to count up the number of times a particular registration number is recorded by voters.  each voter has three choices.  I use =countif to count the number of times each number appears in the three columns of votes.

l set up the tabulation and entry page to account for up to 375 cars.  The first value for car #1 is written as =countif(b2..d375,1).  The next cell down should read the same formulae but just increment the value number by 1.  Excel increments the beginning and ending cell range value so i can't just copy the first cell value after highlighting the remaining 374 cells below.  Is there a way to get excel to do this without altering the range table portion and just incrementing the compare value by 1 for each row below.  I have attached a sample of my problem.
countif-attachment..xlsx
HANDY1FORGODAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
zalazarConnect With a Mentor Commented:
You might try to use the following formula
"=COUNTIF($B$2:$D$376,F2)"

Then in Cell F2 you can put the value 1
In Cell F3 the formula F2 + 1 and then copy down this formula until e.g. F1000 depending on the number of rows you need.
You now can copy the COUNTIF formula.
0
 
HANDY1FORGODAuthor Commented:
You folks are great.  i had an immediate need and not having formal Excel trainng on this aspect, i was losing what hair I had left.

I plugged in the formula as provided and copied the instruction to subsequent 374 cells and the only thing that had to remove on my own before the copy was the quote marks for the incremental formula to work perfectly. Thanks to zalazar for the quick solution.
0
 
zalazarCommented:
I'm glad it's solved and thanks for your appreciation and grade.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.