• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple Criteria and sum the amount

Chief Ace

Member
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
 

Attachments

  • SAMPLE.xlsx
    13.5 KB · Views: 6
For 365 users, I suspect the impressive SUMPRODUCT function is history.

Code:
= SUM(
   SUMIFS(
      Source[amount],
      Source[ID], ID,
      Source[code], codes)
  )
 
Back
Top