Results 1 to 4 of 4

Meal cost per person

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-16-2015
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    121

    Meal cost per person

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 11-03-2019, 01:21 AM
  2. [SOLVED] Formula to Summarize Employee Meal Cost
    By rizmomin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2017, 07:55 PM
  3. [SOLVED] Run calculations in template for 1 person, copy-paste results, repeat for next person
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2014, 06:02 PM
  4. VBA to convert person-to-event into person-person
    By LuckyStrike in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2014, 02:34 PM
  5. Transpose/Pivot multiple rows per person into 1 row per person with fixed columns
    By MaestroEnrique in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2013, 06:35 AM
  6. Replies: 3
    Last Post: 02-27-2007, 05:27 AM
  7. [SOLVED] how do I set up excel sheet for meal break down cost,labor,meat
    By pocket in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-03-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1