+ Reply to Thread
Results 1 to 2 of 2

Comparing columns then multiplying result by particular cell

  1. #1
    Forum Contributor
    Join Date
    04-28-2004
    Location
    Norwich, England
    MS-Off Ver
    2010
    Posts
    119

    Comparing columns then multiplying result by particular cell

    Hallo again!

    Got mysefl stuck on a formulae today...

    I am looking to calculate costs for TYPE taking into account PREFIX in the attached, to go in the blue cells

    In cell AB3 I need to compare column A (DODO1 or DODO2 etc) and Cell M3 (CUP or FORK etc) compared to column D then get the cost from cell R3

    And the same again in cell AC3 getting costs from cell S3

    So that if there are 20 DODO1s which are also FORKS the result in Cell AB3 will be 20 times the cost for FORKS

    Hope that all makes sense!

    I thought I was on the right track trying to adapt my SUMPRODUCT but then got very confused

    Many thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    Try this in cell AB3:

    Please Login or Register  to view this content.
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

+ 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