+ Reply to Thread
Results 1 to 3 of 3

Struggling with SumProduct and Max of 2 criteria

  1. #1
    Registered User
    Join Date
    01-08-2018
    Location
    Pennsylvania, US
    MS-Off Ver
    MS Excel 2010
    Posts
    2

    Struggling with SumProduct and Max of 2 criteria

    Hello All,

    Thank you for this forum it is great. I have a bit of an issue creating a Game Calculator for my casino. Capture.PNG

    Basically I am trying to get a formula for the "Middle Bet" how the game works is your pay out is based on the outcome of both M16 and N16 (whichever is greater) and the wager I20. I already have the payout information in X17:X27 but am trying to get the cell to see which ever is "Greater of an outcome" in M16 and N16 and then inputting that data from X17:X27

    In the photo I have the formula that in my head would work but Excel is REALLY hating me for that formula.

    The other wagers "Across Bet" and "Down Bet" is solved by =SUMPRODUCT(SUMIF($Q$17:$Q$27,$N$16,$W$17:$W$27)) but its just not liking trying to figure out the max of the 2 outcomes and putting that data in.

    For anyone trying to understand the casino game I am talking about it is Criss Cross Poker.

    If I can help clarify anything further please let me know.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: Struggling with SumProduct and Max of 2 criteria

    No-one will be able to help on the basis of a blurry and complicated-looking screenshot.

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential information is removed first!!

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn



  3. #3
    Registered User
    Join Date
    01-08-2018
    Location
    Pennsylvania, US
    MS-Off Ver
    MS Excel 2010
    Posts
    2

    Re: Struggling with SumProduct and Max of 2 criteria

    I apologize about that and for the delay as the excel sheet was on my work computer. Here is the sample Work book as requested.

    Outcomes are all listed in the Black Border Box and will change accordingly if you change the Patron Bets. Sheet is protected without a password so you can play someone can play with it first without worrying about changing something.

    The only formula I need is the "Middle Bet where is choses the best outcome (most money) of the "Across" and "Down".

    Let me know anything else I can provide to assist and thanks in advance to anyone who takes the time to try and help!!!

    Tom
    Attached Files Attached Files

+ 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. Struggling with SUMPRODUCT
    By mjg060468 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-07-2017, 01:07 PM
  2. [SOLVED] Struggling in writing sumproduct formula in excel noclamenture format
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-09-2016, 11:09 AM
  3. Struggling with SUMPRODUCT when matching "time between" values
    By designergav in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-20-2015, 01:07 PM
  4. [SOLVED] Struggling to build count/countif/countifs formula with various comparative criteria!
    By dropanddrive03 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-16-2014, 03:04 AM
  5. Struggling. sum of number of rows which meet criteria across columns
    By tyseley in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-22-2013, 05:43 AM
  6. [SOLVED] I am struggling with sumproduct, pls help
    By edwardlobo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-25-2013, 08:19 AM
  7. Struggling with sumproduct
    By Angel160 in forum Excel General
    Replies: 4
    Last Post: 01-03-2008, 07:08 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