Count with multiple criteria vba

[kelly mort]

I have a data set like this:

Range is B2:J16

With col E and H excluded.

|col A|Col B |Col C |Col D |Col E |Col F |Col G |Col H |Col I |Col J|
|  x  | B   |     B   |     G   |          |    G   |     I    |           |    A  |   A    |
|  y  | A   |     A   |     E   |          |    D   |     D    |           |    F  |   F    |
|  z  | I   |     I   |     F   |          |    A   |     A    |           |    C  |   C    |

|  x  | H   |     C   |     C   |          |    B   |     H    |           |    D  |   D    |
|  y  | B   |     D   |     H   |          |    E   |     E    |           |    F  |   A    |
|  z  | I   |     B   |     G   |          |    G   |     D    |           |    C  |   C    |

|  x  | A   |     A   |     E   |          |    D   |     D    |           |    F  |   F    |
|  y  | I   |     I   |     G   |          |    A   |     A    |           |    C  |   C    |
|  z  | H   |     C   |     C   |          |    B   |     H    |           |    D  |   D    |

|  x  | I   |     D   |     H   |          |    E   |     E    |           |    B  |   A    |
|  y  | B   |     B   |     G   |          |    G   |     I    |           |    C  |   C    |
|  z  | A   |     A   |     E   |          |    D   |     D    |           |    F  |   F    |

|  x  | I   |     I   |     G   |          |    A   |     A    |           |    C  |   C    |
|  y  | H   |     C   |     C   |          |    B   |     H    |           |    D  |   D    |
|  z  | B   |     D   |     H   |          |    E   |     E    |           |    F  |   A    |

And I want to count say all "A" which belong to an "x" in col A. Then all "A" for "y" through to "z" .

Then I repeat that for "B" to "I".

The output show have this format. By filling it with the

|NAME |# of   X |# of  Y  |# of Z    |
| A   |         |         |          |
| B   |         |         |          |
| C   |         |         |          |
| D   |         |         |          |
| E   |         |         |          |
| F   |         |         |          |
| G   |         |         |          |
| H   |         |         |          |
| I   |         |         |          |

 

[sadboy309]

Formula is:

=SUMPRODUCT(($A$2:$A$16=RIGHT(O$1,1))*($B$2:$J$16=$N2))

As Picture:

 

[kelly mort]

Okay cool.

Thanks for it