Hmm. These are tricky formulas, so it might take a bit to understand them and get them working. A few tips: these are array formulas. This means that they work on a range of data, and you have to enter them using Control+Shift+Enter, or they won't work. So set up your sample sheet, select the cell where you want the formula, paste the formula in the formula bar, then hold down the Control and Shift keys, then press Enter. If you don't do that, the formula won't work right, and you might get the zero results.
Next, if you're trying to dissect them, you might be better off starting with the 2 formula set. The single formula is basically a combination of the 2 smaller formulas. When I say, "copy pairwise", in the example above, put the G7 formula in and confirm with CSE. Put the H7 formula in and confirm with CSE. Then select both cells (G7:H7), copy them (Control-C, or right click and select Copy), then select the range you want to put them (I7:N7), and paste them (Control-V or right click and select Paste). Then select G8:N9 and paste again.
To adapt the formulas for your sheet, you'll obviously need to change the ranges in the formulas. If you have trouble doing so, set up your sheets just like my example, and when it's working, just add/delete rows/columns until it matches what you want, Excel will adapt the formulas for you.
Finally, you can't upload a sheet to the forum, but you can use a tool such as the HTML Maker (see my signature) to show a sample like I did. You can also upload a file to a file sharing service (like Dropbox) and post a link, but many people will not download files from the internet, limiting the number of people who might help you.
Let me know if you have further questions.