COUNTIF/SUMPRODUCT(?) to create a matrix from data

Thank you very much Glenn. The bottom right cell of my data is BN131. I have added all the data into the worksheet you provided and updated where appropriate the references in the named ranges to refer to row 131 and column BO (ie one after BN, the last column with data). However, I'm getting some odd and incomplete results and wonder if you'd be so kind as to point out where I've gone wrong?