sum combining data from more than one tables?

Hi all, i was wondering if a sumifs or other formulas (not vba) in excel 2019 can calculate a sum combining data from more than one tables:

for example i got a table with POs with say three columns and the following dummy data:

po id, date, customer
po1, 1/11/2020, cus-A
po2, 2/11/2020, cus-A
...

and i got a table with PO lines with say three columns and the following dummy data:
po id, item id, quantity
po1, it-1, 10
po1, it-2, 10
po2, it-1, 5
...

now i want to know how many it-2 items i sold to cus-A customer having as a "link" the po id in both tables in the example above

any ideas/directions much appreciated
thx!

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

if POs are sorted

=SUMPRODUCT((LOOKUP(A8:A10,A3:C4)=C3)*(B8:B10=B9),C8:C10)

if not sort
=SUMPRODUCT((VLOOKUP(T(IF(1,+A8:A10)),A3:C4,3,0)=C3)*(B8:B10=B9),C8:C10)
Ctrl+Shift+Enter

Try

=SUMPRODUCT((LOOKUP($A$8:$A$10,$A$3:$A$4,$C$3:$C$4)=E3)*($B$8:$B$10=F3),$C$8:$C$10)

and
=SUMPRODUCT((VLOOKUP(T(IF(1,+$A$8:$A$10)),$A$3:$C$4,3,0)=E3)*($B$8:$B$10=F3),$C$8:$C$10)