• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

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
0
HANDY1FORGOD
Asked:
HANDY1FORGOD
  • 2
1 Solution
 
zalazarCommented:
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

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now