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