B
Bennington
I have a spreadsheet where each row consists of the name of a particula
election candidate in the first column, then a space where I want
formula, and then each column after that contains the name of a voter
or nothing, if that voter didn't vote for that candidate. There ar
around 350 candidates and 22 voters
I want to write a formula in the second column that will count th
number of non-empty cells to its right in the row, thus counting th
number of votes that candidate received
While COUNTA(C2:X2) works just fine for the first row, I'd have t
retype those numbers 350 times
Is there any way I can make the formula refer only to the row that th
formula is in, excluding the formula and the name of the candidate, o
course? That way, I could place the same formula in each row. Help i
appreciated
EDIT: Solved my own problem. Didn't realize Excel adjusts cell number
when you copy/paste
election candidate in the first column, then a space where I want
formula, and then each column after that contains the name of a voter
or nothing, if that voter didn't vote for that candidate. There ar
around 350 candidates and 22 voters
I want to write a formula in the second column that will count th
number of non-empty cells to its right in the row, thus counting th
number of votes that candidate received
While COUNTA(C2:X2) works just fine for the first row, I'd have t
retype those numbers 350 times
Is there any way I can make the formula refer only to the row that th
formula is in, excluding the formula and the name of the candidate, o
course? That way, I could place the same formula in each row. Help i
appreciated
EDIT: Solved my own problem. Didn't realize Excel adjusts cell number
when you copy/paste