Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count Non-Empty Cells In Each Row
I have a spreadsheet where each row consists of the name of a particular election candidate in the first column, then a space where I want a 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 are around 350 candidates and 22 voters.
I want to write a formula in the second column that will count the number of non-empty cells to its right in the row, thus counting the number of votes that candidate received. While COUNTA(C2:X2) works just fine for the first row, I'd have to retype those numbers 350 times. Is there any way I can make the formula refer only to the row that the formula is in, excluding the formula and the name of the candidate, of course? That way, I could place the same formula in each row. Help is appreciated. EDIT: Solved my own problem. Didn't realize Excel adjusts cell numbers when you copy/paste. Last edited by Bennington : April 17th 12 at 07:28 PM |
#2
|
|||
|
|||
Quote:
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Non-Empty Cells In Each Row
=countif(range,"*")
=countif(A1:A10,"*") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count no empty cells at the right of a selection | Excel Programming | |||
How to count non-empty cells | Excel Programming | |||
Count Empty Cells in Range After Cells with Data | Excel Programming | |||
count for empty cells | Excel Discussion (Misc queries) | |||
How do I count cells in spreadsheet that are not empty? | Excel Programming |