Google Sheets: Drop Down menu, price, totals

[ZZZ14]

Hi my name is Zue,
I have little knowledge in excel and English isn't my 1st language.
My husband needs to create a drop down food menu, price and total
Capture1.PNG
Hope some one can guide me.
Thanks in advance and happy and prosperous 2021!

[Limor_OP]

Hi,
Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[ZZZ14]

I'm trying to upload the sheet but I can't

[ZZZ14]

I'm trying to upload the sheet but I can't

[JeteMc]

Perhaps the following will help.
1. Populate column B using data validation: Allow > List; Source > ='PLATES AND PRICE'!$A$3:$A$26; In-cell dropdown is checked
2. Populate column C using: =IF(B3="","",SUMIFS('PLATES AND PRICE'!B$3:B$26,'PLATES AND PRICE'!A$3:A$26,B3))
3. Populate column E using: =IF(B3="","",PRODUCT(C3:D3))
Let us know if you have any questions.