Solved

Need help with Excel 2007 =countif

Posted on 2013-11-17
3
328 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
  • 2
3 Comments
 
LVL 11

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 11

Expert Comment

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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

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.
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
Viewers will learn the different options available in the Backstage view in Excel 2013.

792 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