Xlookup & sum

[lynusann]

Hi all! It's been a while since I've been here, but you guys never fail me so I'm back hoping someone can push me in the right direction (or a boot up my **** in the right direction is welcome too)

Working in 365 on a Mac.

I have a workbook with multiple sheets. The first sheet tracks all my product barcodes, the product cost, the product profit margin and who "owns" the product.

2nd sheet tracks monthly sales reported back to me via barcode from the store, and the amount of commission fee the store kept. So I've managed to, through what I think is a very bastardized xlookup formula, managed to pull info over from the 1st sheet and place the "owners" name next to each product sold. In the Net Profit column I've managed to also pull over, via XLOOKUP, the product cost, subtracted from what the shop actually pays us. Finally, each of the 3 people involved get different percentages of net profit, so I think I have successfully parsed that down.

I included screen shots of the 3 pieces above to show my formulas and where they're going/derived from.
Screen Shot 2020-07-18 at 9.31.11 PM.png
Screen Shot 2020-07-18 at 9.31.21 PM.png
Screen Shot 2020-07-18 at 9.31.31 PM.png

And the first worksheet that I'm pulling info from:
Screen Shot 2020-07-18 at 9.32.02 PM.png


So here's where I'm running into problems with my limited understanding of xlookup: I need to get a sum for what is owed to each of the 3 people from the "Owed to" column. But my xlookup formula stops after the 1st box. Spent about 3 hours watching youtube tutorials and I'm no further along than when I started.
Screen Shot 2020-07-18 at 9.31.49 PM.png

Any fixes or direction would be much appreciated!

[Fluff13]

Have a look at the SUMIFS function
https://exceljet.net/excel-functions...umifs-function

[lynusann]

Thank you. I am honestly winging all this excel stuff on a daily basis. Much appreciated!

[Fluff13]

You're welcome & thanks for the feedback.

[Gregb11]

If you need more assistance, please make sure to attach a sample file to make it easier to help you. See the yellow banner at the top of the page.