+ Reply to Thread
Results 1 to 2 of 2

total of cell range in 2 matrixes using 2 cells for reference

  1. #1
    Registered User
    Join Date
    01-04-2007
    Posts
    10

    total of cell range in 2 matrixes using 2 cells for reference

    Good morning,

    Currently I have 1 doc with 2 pages.

    page 1 = 2 separate pricing matrixes (grouped)
    I am calling them lights and darks.

    example of one:
    -------------------1----------2-----------3-------------4---
    23-56---------$5-------$10--------$15--------$20
    57-78--------$10-------$15-------$20 --------$25
    79-101------$15-------$20--------$25--------$30

    page 2 = quote sheet
    In this sheet I have a drop down menu with 2 options (lights, darks).
    This way a single matrix is used for reference.
    There are 2 cells that must be filled with a number to reference what the price is with a final cell that displays the total.

    cell 1 = quantity (rows) ex: 60
    cell 2 = number of embellishments (columns) ex: 3
    cell 3 = price (row/column total) ex: $20.00

    Could use some help with the drop down also.
    I don't know how to specify what group is used for reference when that option is selected.

    Thanks in advance and appreciate any feedback.

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626

    See the attachment

    I think this is what you need
    Attached Files Attached Files
    I need your support to add reputations if my solution works.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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