SUM IF AND VLOOKUP. How together?

Question

excel

Tell me how to use SUMIF and VLOOKUP together? It is necessary to take the total quantity of the purchased goods
from sheet #2 and substitute the figure in Sheet1.
That is, VLOOKUP looks at the value of the article on sheet #1 , then goes to the second sheet, looks for all the lines with the article there, sums up the value of the cell quantity and writes them into the cell on 1 sheet.
I try something like this, but the error is:

=SUMIF(Ценообразование[Артикул]; VLOOKUP($D$2; 'Поступление_товара'!$E$4:$G$60;2, FALSE); Ценообразование[Кол-во])

Answer 1

Try SUMIF (), SUMIFS () or FILTER (), this looks like what you need