Hi Bexi

Try
=SUMPRODUCT(--(MID(Sheet1!$A$1:$A$17,6,3)="88B"),Sheet1!$C$1:$C$ 17)

or
=SUMPRODUCT(--(MID(Sheet1!$A$1:$A$17,6,3)=MID(A1,6,3)),Sheet1!$C $1:$C$17)


Regards

Roger Govier


Bexi wrote:
Hello,

I want to add the amount based on column A if the text in A contains
*88B and my data looks like this

Sheet1
A B C
AI 1088B AA886 2500
KA1088B AA886 3000
AAA1088B AA886 1000

Sheet2
A B C
AAA1088B AA886

The formula is in Sheet2 column C.

I used this formula but it returned FALSE
=IF(MID(A1,6,2)=MID(A1,6,2),SUMPRODUCT((A1:B17),G1 5:G17))

Please help.
Thanks
Bexi