@spyman: I assume you had 100 rows per filter? And by filtering out the GG combos you are left with 76. So far so good. That is the total number of outcomes given the assumption that they aren't noth girls. Now from that set - whih again is the total number of outcomes do an
And(A2="Boy",B2="Boy")
To get the number of favorable outcomes, remember the definition of Probability = fab/possible. You should get about 25. Which is about 3/4. Since youre doing this empirically, the larger number of rows, the closer you'll get to 25% favorable out of 75% total, then divide and you'll get 33%
That's trying to explain your excel results. But it's really easier when only dealing with 2 possible out comes of 2 events to just write them all out. These are the only possibilities:
GG
GB
BG
BB
the original assumption is that at least one is a boy, leaving you with
GB
BG
BB
three possible outcomes. Now of those, how many are favorable? That is, given one boy, the other is also a boy, in other words two boys. Only one of the three matches that criterion, therefore fav = 1 and possible = 3, so fav/pos = 1/3
Does that clear it up?