Can you please have a look that attached file, to Sheet1 B2 and B3 cells I am searching some formula, which would be able to do a kind of subtotal from Sheet2 data.
So writing the formulas in words
cell B2 = sum of Qty-ies from Sheet2 where Car1 is on Sheet2 in column A
cell B3 = sum of Qty-ies from Sheet2 where Car2 is on Sheet2 in column A
Could you please advise which formula can be proper to this, maybe VLOOKUP or SUBTOTAL?