Fun With Functions

  • Thread starter Thread starter Liv
  • Start date Start date
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!
 
Assuming your data is in Columns A:L starting in row 1:
In the thirteenth column, in row 1, enter "=COUNTA(A1:L1)" without the
quotes.
This produces a number equal to the number of entries in that row. Drag
this formula down as far as your data goes. In the next cell down, sum all
the values in that column. Done. HTH Otto
 
If they are numeric values like you show in your example, then =COUNT(A2:A12)
should do the trick.
 
Back
Top