# Need help making a formula for % chance of all combinations of [set 1] + [set 2] > k

1. ## Need help making a formula for % chance of all combinations of [set 1] + [set 2] > k

To give an example situation of the formula I need:

Golden State Warriors vs Utah Jazz's past matchups within the last 4 years show that GS scores between [79-132] and Utah between [92-126] (dataset 1 and 2, respectively). Voiding all possibilities of draws, and assuming all other combinations of scores in these ranges are equally likely, the probability that this matchup will score a total greater than ___ is ___%.

Essentially trying to get a % chance output where x>k from a giant probability tree, but voiding where both datasets would use/add the same number.

Thank you,
N0043

2. ## Re: Need help making a formula for % chance of all combinations of [set 1] + [set 2] > k

Hello N0043 and Welcome to Excel Forum.
This proposes a low-tech way:
1. Populate B1 with the value used for K
2. Populate B2 with: =COUNTIFS(D2:AL55,">"&B1,D2:AL55,"<>")/COUNTIFS(D2:AL55,"<>")
3. Populate C2:C55 with GS scores: 79:132 (this may be quickly done typing 79 into cell C2, right clicking the fill handle, pull down and back up, select series, select column and type 132 into the Stop Value window)
4. Populate D1:AL1 with Utah Jazz scores 92:126 (this may be quickly done typing 92 into cell D1, right clicking the fill handle, pull down and back up, select series, row should already be selected and type 126 into the Stop Value window)
5. Populate D2:AL55 with: =IF(\$C2=D\$1,"",SUM(\$C2,D\$1))
Let us know if you have any questions.

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