probability distribution count if complicated conditions....

Thanks Andrew,
It is for a summer class and I understand that you don't want to give me the answer.

But I don't understand where you see I'm dividing things... and the MOD function is to find remainders...

The question is asking what is the probability distribution of winning, losing and draw (neither win nor loose).

I've been using the Count.if function for simple probability, (how many times will the dice land on 1, 2, 3 etc.) but here it's too complicated for me. That's where I need the help.

I'm joining the excel file. You'll be able to better see how I'm thinking (and that may be the problem!!!)

It's easy to say that dice throws that obtain the sum of 2, 5, 7 or 9 either loose or win because the only possibilities of obtaining those numbers are either all win, all loose or all draw. (For example to obtain 2 there is only 1+1, so it's a win, to obtain 5 you can either have 1+4 or 2+3 and those both fall into the "draw" category, so they neither win nor lose.)

What is making me sweat is the 4... you can get 4 by either 2+2 (draw) or 3+1 (win)... And the problem is finding out what the distribution of wins, losses and draws there are.

I hope I'm being clear... cause it's really complicated for me to explain (and to understand!!)

Thanks for your help!
Cynthiaexercice 3.xlsx