problem sumproduct ?

dear all,

i successfully did with {=sum(if...)}

i now wanna the same result with sumproduct, but result is zero

=SUMPRODUCT(--(NOT(TEXT($F$7:$AJ$7,"ddd")="SUN"))*(LEFT((F40:AJ40),1)="A"),RIGHT(F40:AJ40)) -> result is 0

=SUMPRODUCT(--(NOT(TEXT($F$7:$AJ$7,"ddd")="SUN"))*(LEFT((F40:AJ40),1)="A"),value(RIGHT(F40:AJ40))) --> result is #value

thanks for your help,
vumian