=SUMPRODUCT(--(B13476="CB"),--(D13476="N")--(D13476="Y"),W13476*8)+SUMPRODUCT(--(B13476="S"),--(D13476="N")--(D13476="Y"),W13476*8)+SUMPRODUCT(--(B13476="DE"),--(D13476="N"),W13476*12)+SUMPRODUCT(--(B13476="DE"),--(D13476="Y"),W13476*8)+SUMPRODUCT(--(B13476="DT"),--(D13476="N"),W13476*12)+SUMPRODUCT(--(B13476="DT"),--(D13476="Y"),W13476*8)+SUMPRODUCT(--(B13476="IB"),--(D13476="N")--(D13476="Y"),W13476*10)+SUMPRODUCT(--(B13476="OB"),--(D13476="N"),W13476*12)+SUMPRODUCT(--(B13476="OB"),--(D13476="Y"),W13476*10)

The formula looks at cells in columns B & D and if the answers are correct it multiplies column W by a certain figure. In certain parts of the formula the cell in column D can either be a Y or N. What I am hoping to find is an easier, more simplified formula than this. Is this possible or do I have it the best it can be?

Thanks for all the help. I hope I am clear enough for you.

Bill