Thanks all for your suggestions. Maybe my problem is that I've broken out

the scores according to the criteria for each of four scenarios. Ultimately,

all I need is one answer, ranging from 0 to 3. I know that this is possible,

but I just don't know how to write a formula that works.

Scenario 1: If 11, 11A, and 11B=4, score = 3

=IF(AND(C17=4,C23=4,C29=4),3,"")

Scenario 2: If 11 AND 11A=3 OR 11b=3, score = 2

=IF(OR(AND(C16=3,C22=3),C28=3),2,"")

Scenario 3: If 11=1, score 0

=IF(AND(C14=1),0,"")

Scenario 4: All others score 11 = 1

=IF(AND(ROUND(C31,n)=0,ROUND(C32,n)=0,ROUND(C33,n)=0),1,"")