sumproduct formula help

[Pauljj]

I thought the formula below would work....but it isn't

=SUMPRODUCT(--ISNUMBER(MATCH(AY$20:AY$500,{"W","X","Y","Z","F","T"},1)),--(BB$20:BB$500="Redeemed"),--(BA$20:BA$500>38869),AZ$20:AZ$500)


This is meant to be summing up range AZ20:AZ500 if.....

range BA20:BA500 has a date larger then 38869 and

if range BB20:BB500 has the words redeemed in it and

range AY20:AY500 has a code which starts with any of these letters W or X or Y or Z or F or T

It's this last part which I think I have wrong...the problem is I don't know how to correct it, does anyone have any clues please ?

 

[VoG]

Try

=SUMPRODUCT(--ISNUMBER(MATCH(LEFT(AY$20:AY$500,1),{"W","X","Y","Z","F","T"},0)),--(BB$20:BB$500="Redeemed"),--(BA$20:BA$500>38869),AZ$20:AZ$500)

 

[Pauljj]

Thanks VoG. When someone gives you the answer more often then not it seems obvious and you question yourself how you didn't think of it....unfortunately thats my problem nearly all the time. Thanks for your help much appreciated