Quicky: Sumproduct with multiple conds, and one condition contains an 'or'

[ClimoC]

Hey everyone. I have this function:

=SUMPRODUCT(--($M$6:$M$500=AS$5),--($F$6:$F$500="SD"),$S$6:$S$500)

Which works fine - but I need the second condition to actually be
if any cell in this range is "SD" or "SD&HD"

Then it'll all be dapper.

Ta

 

[barry houdini]

One way to do that

=SUMPRODUCT(--($M$6:$M$500=AS$5),($F$6:$F$500="SD")+($F$6:$F$500="SD&HD"),$S$6:$S$500)