Solved

Need help with Excel 2007 =countif

Posted on 2013-11-17
3
330 Views
Last Modified: 2013-11-17
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
Comment
Question by:HANDY1FORGOD
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
zalazar earned 500 total points
ID: 39654997
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
 

Author Closing Comment

by:HANDY1FORGOD
ID: 39655091
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
 
LVL 12

Expert Comment

by:zalazar
ID: 39655115
I'm glad it's solved and thanks for your appreciation and grade.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question