sum1 -- count = count +1
 

I have 4 columns with 0, 1 answers. I need to count the number of rows that
countain at least one 1.
--
Scott Miller
University of Washington
Chemistry

sum1 -- count = count +1
 

Scott,

use an extra column to sum the answers (e.g. in K2 =SUM(F2:I2) and
copy down). Then use
=COUNTIF(K:K, "1").

HTH
Kostis Vezerides

sum1 -- count = count +1
 

Let's assume that your data is in cols A-D. In col E enter:

=MIN(A1+B1+C1+D1,1) and copy down

Then just sum column E
--
Gary's Student


"Scott" wrote:

I have 4 columns with 0, 1 answers. I need to count the number of rows that
countain at least one 1.
--
Scott Miller
University of Washington
Chemistry

sum1 -- count = count +1
 

It there a way to do this without effecting the data table? I want to
preserve the asthetic valur of the table including only answers to survey
questions.
--
Scott Miller
University of Washington
Chemistry


"Gary''s Student" wrote:

Let's assume that your data is in cols A-D. In col E enter:

=MIN(A1+B1+C1+D1,1) and copy down

Then just sum column E
--
Gary's Student


"Scott" wrote:

I have 4 columns with 0, 1 answers. I need to count the number of rows that
countain at least one 1.
--
Scott Miller
University of Washington
Chemistry

sum1 -- count = count +1
 

There's probably a better way, but here's an array formula:
=SUM(SIGN(A1:A10+B1:B10+C1:C10+D1:D10))

Note that any text will cause an error.
--
Dana DeLouis
Win XP & Office 2003


"Scott" wrote in message
...
I have 4 columns with 0, 1 answers. I need to count the number of rows that
countain at least one 1.
--
Scott Miller
University of Washington
Chemistry