Can this formula be condensed or simplified?

[easybpw]

I have this formula that gives me the correct results I am looking for. However I am hoping there is an easier formula or one that condenses what I have and simplifies it. Here is my formula:

=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

 

[easybpw]

Thanks I will! Thanks to Aladin and Oaktree!

Bill

 

[Sanador]

Is this what I need?

I am very slightly familiar with VLOOKUP and SUMPRODUCT as I am with most of Excel. Currently I am using the following formula:

=SUMPRODUCT(--('05-06'!$E$9:$E$1000="F"),--('05-06'!$F$9:$F$1000="12"),--(('05-06'!$K$9:$K$1000=$BL50)+('05-06'!$N$9:$N$1000=$BL50)+('05-06'!$Q$9:$Q$1000=$BL50)+('05-06'!$T$9:$T$1000=$BL50)>0))

to derive some data from a column on sheet "05-06." In the example above, I am looking for 12th grade girls who have an entry equalling the text value in cell BL50. What I need to add is a way to further limit this result so that it chooses from one more set of values. Each student's row contains a field for "SPORT" that I'd like to incorporate somehow. I want to choose only those students who participated in a fall season sport. These sports are listed in various locations, one of which is BJ50:BJ76. Is there a simple way I can slip this into my formula without adding 27 more SUMPRODUCT arguments?