Search database for matches and add totals

Hi Guru’s

Stumped on another one and wondering if I can get some expert help?

I need C5 to look for:

- B5 in row H
- C3 to look in row J
- B3 to match in row I
- Add qty in row K

Manual answer in C5 = 4

I need D5 to look for:

- B5 in row H
- C3 to look in row J
- B3 to match in row I
- Add $ qty in row L

Manual answer in C5 = $175


Preferably without using an array formula as it’s a large(ish) database.


Many thanks!

Thank you again Bebo - Champion!

Thank you DJ - appreciate your input!

Tanks for the feedback, glad to help.