Sumproduct using Left and Right

Hi all.

I try this =SUMPRODUCT((LEFT('3'!$M$15:$AG$30)=$C$2)*(RIGHT('3'!$M$15:$AG$30)=$C$2)*('3'!$M$8:$AG$8=$C$1)*('3'!$L$15:$L$30=$B3))
It work if Left or Right only? But need both Left and Right as I have WW, WL, LW, W and L in the cell.

I have try SUMPRODUCT(--(Left('3'!$M$15:$AG$30)=$C$2),--(RIGHT('3'!$M$15:$AG$30)=$C$2),--('3'!$M$8:$AG$8=$C$1),--('3'!$L$15:$L$30=$B3))
It come up VALUE#

Any idea!

If need sample file let me know?

Regard

here sample file looking for Left and right in total sum

If a cell has WW in it, should it count as 1 or 2 for the W column?

Count 2 if WW and count 1 if just W?
Same as LL count 2, count 1 if L?
If WL or LW count 1 each.

Then you could use:

=SUMPRODUCT((LEN($J$3:$T$18)-LEN(SUBSTITUTE($J$3:$T$18,$C$2,"")))*(RIGHT($J$3:$T$18)=$C$2)*($J$2:$T2=$C$1)*($I$3:$I$18=$B3))

Typo in earlier formula. Should be:

=SUMPRODUCT((LEN($J$3:$T$18)-LEN(SUBSTITUTE($J$3:$T$18,$C$2,"")))*($J$2:$T$2=$C$1)*($I$3:$I$18=$B3))

Thank you rorya and tim210110.

rorya, your first formula was not right till you post 2nd one? Now it correct formula in sample and my main file.
tim210110, your was very close!

Now it solved
add rep!