How to apply if and sumifs function in this case

[mirandataran]

Hello,

I need to combine if and sumifs function for this case that i have. (according to my lecture)
The case is : to fill product cost column (Sheet 1) , they asked me to put the sum of unit price ( in Sheet 2) if the product type (Sheet 1) is Manufactured. If the product type is Bought-in, the product cost is equal to purchase price (in Sheet 1).

Sheet 1

Purchase price Product type Product cost
100 bought in ?
40 bought in ?
0 manufactured ?
20 bought in ?
0 manufactured ?

Sheet 2

Unit price
100
20
78
98

In addition, i could not rename any table in sheet 1 or sheet 2. Moreover i need to use both if and sumifs in this case.
Thank you in advance.

 

[jtakw]

Hi,

Since we don't do your homework for you.
What have you tried, according to what you've learnt from the lecture(s), and your research?
Also, your table seems incomplete based on your description.

 

[mirandataran]

Thank you for your reply
yes the table that i showed is not the complete one.
But i already came up with the answer. Anyway thanks for replying