Formula to sum with two criteria joint horizontal vertical

Please to me the formula for below sample,

Name. Basket. Tray. Basket. Tray

Apple. 10. 15. 5. 5
Orange. 4. 12. 8. 10


Quantity apple in basket, should be 15 and tray 20
Same orange basket =12 and tray 22

Please help for the formula. Thanks

Hi there,

Used below formula in attached workbook:-

Formula:

Please Login or Register  to view this content.

two criteria - horizontal.xlsx

Regards,
DILIPandey
<click on below * if this helps>

Thank you very much. Its great!!

you are welcome ..

Suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey
<click on below * if this helps>