Some text SumProduct

[Dawn]

Hello all
I am trying to sum cell contents D5111 based on partial text match of
B5:B111.
How do I enter sumproduct criteria for the following criteria?:
First 4 text characters = ABCD and the Last Character = Q

ABCD-xxxxxxx-Q Sum
SFDG-xxxxx-Z dont sum

THanks
Dawn

 

[Govind]

Hi Dawn,

Use

=SUMPRODUCT((LEFT(B5:B111,4)="ABCD")*(RIGHT(B5:B111,1)="Q")*(D5111))

Regards

Govind.

 

[Dawn]

Thanks!

Hi Dawn,

Use

=SUMPRODUCT((LEFT(B5:B111,4)="ABCD")*(RIGHT(B5:B111,1)="Q")*(D5111))

Regards

Govind.