Meal cost per person

[forestview]

Hi, Please see attached sheet which has 3 tabs Orders, Menu and Headings, on the Orders tab i want to get cost of a persons meal based on selection from drop down list, Headings tab has the list of drop down headers with associated cost, ine tried using Sumifs and Sumproducts to no avail and cant see where im going wrong, any help or pointer in the correct direction would be appreciated

[AliGW]

See if this does what you want:

=SUMPRODUCT(((Headings!$A$2:$A$16=C2)+(Headings!$A$2:$A$16=D2)+(Headings!$A$2:$A$16=E2))*(Headings!$B$2:$B$16))

[forestview]

Hi AliGW
Thank you very much

That did the trick

[AliGW]

The difference was + instead of * (+ is OR, * is AND).

If you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.