Counting letters

[kevincoxshall]

Hi all
Please help on this one, been scratching my head all morning..........

I have a table like this.........

Item Code
Ice A
Ice A
Ice B
water D
water A
water C
water A
milk B
milk D
milk C
milk C
milk C
milk B

and i would like to count the number of each letter to look like........
_______ A B C D
Ice ___ 2 1 0 0
water _ 2 0 1 1
milk ___0 2 3 1

Hope you can help

Kevin

[martindwilson]

use sumproduct like this
=SUMPRODUCT(($A$1:$A$13=$E2)*($B$1:$B$13=F$1))
see attached

[kevincoxshall]

Excellent thank you so much
Kevin