Possible Hand Combinations

[sillyarms]

I have been trying to recreate the Sklansky-Karlson 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 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