Using Count/Frequency/Binning to sort data

Hello All,

I have a large amount of data that is in two columns and I am trying to use some kind of formula to count the number of times a measurement falls between two values in each column and then use that data to populate a table. I've attached an example which shows a very simplified version of what I'm after.

In the example the X and the Y colums have the values and I want to populate the table on the right with how many samples with X = 1 also have Y =1 and how many have Y=2 etc. I've included my best shot so far but it isn't anywhere near what I'm after. The ultimate goal is to produce a surface plot and also analyse the count data in a statistical package (yet to be sourced).

Any help with this either through functions or coding would be much appreciated.

Thanks

Jarvice