Multiple Criteria and sum the amount

[Chief Ace]

Greetings Excel Gurus
,
I have been trying to figure this out to no avail. As you can see in the file attachment, in column "B" when there is an "A68" and it correspond in column "C" when there is a letter that starts with "R or "L" (using a wildcard) then it should sum up the amount.

As for the example in the attachment:
Cell B10 there is A68 and on C10 the letter starts with the letter "L" with the amount of 69.28 then on cell B13 there is A68 and on C13 the letter start with letter "R" with the amount of 184.72 then this two amounts should be added that equals to
254.

For the life of me i cannot get it to work and i used different approach. Kindly needed someone to enlighten me. Thank you in advance.

Regards
Chief Ace

 

[bosco_yip]

Try this formula :

=SUMPRODUCT(SUMIFS(D:D,B:B,G4,C:C,G5:G6))

The result return : 254

Regards

 

[Chief Ace]

Hi Bosco_yip,

Yes that is it....i greatly appreciate the quick response...Thank you.

Cheers,
Chief Ace

 

[Peter Bartholomew]

For 365 users, I suspect the impressive SUMPRODUCT function is history.

= SUM(
   SUMIFS(
      Source[amount],
      Source[ID], ID,
      Source[code], codes)
  )