S
Scott
I have 4 columns with 0, 1 answers. I need to count the number of rows that
countain at least one 1.
countain at least one 1.
V
vezerid
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
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
G
Gary''s Student
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
=MIN(A1+B1+C1+D1,1) and copy down
Then just sum column E
S
Scott
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.
preserve the asthetic valur of the table including only answers to survey
questions.
D
Dana DeLouis
There's probably a better way, but here's an array formula:
=SUM(SIGN(A1:A10+B1:B10+C1:C10+D1
10))
Note that any text will cause an error.
=SUM(SIGN(A1:A10+B1:B10+C1:C10+D1
10))Note that any text will cause an error.