L
Liv
Hi there,
I need help with Excel! Here's the scenario. My spreadsheet has 12
columns associated with each row. Each row contains 12 separate
numbers within those columns. What I want to do is create a new column
with a cell in each row that the following:
1. Looks for values in each cell across the row.
2. For each value Excel finds within a cell of the row, Excel should
assign 1 point.
3. Excel then sums the number of cells in the row that have values (not
a sum of the actual values in the cells) in this same new cell.
IF cell value is greater than 0, then value=1. SUM values of 1 for
each cell within the row.
Here is an example and the new column the above details reference is #
Mos True
Jan Feb Mar # Mos True
George 1 2 3 3
Kramer 5 1
Elaine 4 1 2
Thank you!
I need help with Excel! Here's the scenario. My spreadsheet has 12
columns associated with each row. Each row contains 12 separate
numbers within those columns. What I want to do is create a new column
with a cell in each row that the following:
1. Looks for values in each cell across the row.
2. For each value Excel finds within a cell of the row, Excel should
assign 1 point.
3. Excel then sums the number of cells in the row that have values (not
a sum of the actual values in the cells) in this same new cell.
IF cell value is greater than 0, then value=1. SUM values of 1 for
each cell within the row.
Here is an example and the new column the above details reference is #
Mos True
Jan Feb Mar # Mos True
George 1 2 3 3
Kramer 5 1
Elaine 4 1 2
Thank you!