+ Reply to Thread
Results 1 to 2 of 2

Formula for when the sum depends on data in numerous cells.

  1. #1
    Registered User
    Join Date
    01-26-2015
    Location
    Haydock
    MS-Off Ver
    13
    Posts
    4

    Formula for when the sum depends on data in numerous cells.

    Hi,
    I've been reseraching for a good couple of weeks now but can't find the information i need to work this one out.
    I'm not even sure if i'll be able to explain clearly what i'd like to be able to do.
    I've attached my current spreadsheet as it is.

    Untitled.jpg

    What i'd like to do is be able to add up the cost of a wedding album based on various options chosen by my customers to make it as simple and as clear as possible for them.
    The customer would chose the album name, the album size, the page count, type of paper and thickkness and then the formula would work out the cost based on the set prices for each option given by the album supplier.
    The problem im coming up with is the variable side of it so to try and explain a bit more...
    The same album, same size with 60 pages is obviously going to cost more than one with 40 pages, but that could then depend on the type of paper and thickness chosen for that album.

    I hope that makes sense, in my head it does anyway. I'd be so grateful for any help with this so if you can and dont mind it'd be very much appreciated, if you need more information please ask. Thank you so much in advance, Stuart.
    Attached Files Attached Files
    Last edited by bluenose_1878; 01-26-2015 at 09:06 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Formula for when the sum depends on data in numerous cells.

    Perhaps you could include a few (different) sample albums and show manually how they would be calculated?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Ms access Vba Save Data to xl depends upon 1 table pick & Depends 2 Upon fiterDate
    By breadwinner in forum Access Programming / VBA / Macros
    Replies: 14
    Last Post: 05-29-2014, 10:59 PM
  2. Formula Required to Summarize Text Values in Numerous Cells
    By wizzer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-23-2013, 02:57 PM
  3. Adding $ to formula in numerous cells
    By stba2006 in forum Excel General
    Replies: 4
    Last Post: 08-13-2010, 12:44 PM
  4. propogating cells with data from numerous sheets
    By G. Beard in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2005, 07:05 PM
  5. Replies: 2
    Last Post: 08-25-2005, 02:05 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