[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

# Need help with Excel 2007 =countif

Posted on 2013-11-17
Medium Priority
344 Views
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
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
• 2

LVL 12

Accepted Solution

zalazar earned 2000 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

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

ID: 39655115
0

## Featured Post

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
###### Suggested Courses
Course of the Month13 days, 3 hours left to enroll