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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm glad it's solved and thanks for your appreciation and grade.
ASKER
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.