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.