Well - you could either "long-hand" the formula, or - you might consider using the UNPIVOT clause to normalize you data, and then use something like SUM(case answer when 1 then 1 else 0 end)
In other words - use UNPIVOT to turn your one row, many repeating columns into many shorter rows with no repeating columns.
Without some specific as to your table structure - I can't give you any specifics, but Books Online has some decent examples.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?