+ Reply to Thread
Results 1 to 12 of 12

Sum the cost of the selected ingredients for each burger, to give total cost of burger.

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    Re: Sum the cost of the selected ingredients for each burger, to give total cost of burger

    CatSqueezer, Good morning.

    Take a look at it.
    20-03-2014_ExcelForum_Book1.xls

    Is it what you want?
    I hope it helps.
    ...If my answer helped you, Please, click on. * Add Reputation (at left)

    Best regards.
    Marc?lio Lob?o

  2. #2
    Registered User
    Join Date
    12-04-2013
    Location
    Oxford, England
    MS-Off Ver
    Excel 2000
    Posts
    93

    Re: Sum the cost of the selected ingredients for each burger, to give total cost of burger

    HI Mazzaropi, your solution is the most elegant, and it doesn't even need an array. Thank you very much, l have adapted and used it (l don't need the Vlookup actually, l refer directly to value cells, instead of referring to the titles of those cells). Rep point on its way!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. The Repeating Cheese burger Code
    By ScoGeosan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2012, 11:34 AM
  2. Calculating total cost from range of cell tally's by cost of item.
    By patrickdjames in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 11-04-2012, 10:27 AM
  3. [SOLVED] Duration of phone call and total cost.....how to work ut cost per minute ?l
    By monkeyman90210 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2012, 04:18 AM
  4. [SOLVED] Outputing engineering cost based on total cost of project. Looking for help with matching
    By cadamhill in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-17-2012, 09:31 PM
  5. Replies: 3
    Last Post: 03-16-2010, 01:26 PM

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