Possible Hand Combinations

[sillyarms]

I have been trying to recreate the Sklansky-Karlson (http://archiveserver.twoplustwo.com/showflat.php?Cat=&Number=382772&page=&view=&sb=5&o =&fpart=all&vc=1) hand rankings using microsoft excel. However I have run into a problem figuring out the number of possible hand combinations when I hold a specific hand. Because of the fact that excel can only have 7 nested IF statements. HERE (http://68.184.12.70/twoplustwo/sklanksy-carlson%20test.xls) is a link to the spreadsheet I am using. Every number in column B in the HandCombos worksheed should add up to 1225, however they do not and I cannot go any deeper into the if statements. Can anyone help me by telling me a formula I can enter that will give me the correct numbers, or an easier/better way of doing it?


silly