Assuming your data in A2:A10
your summary:
A14: holds A
B13: holds BOM
C13: holds NAA
D13: holds NWD

B14: =SUMPRODUCT(--($A$2:$A$10=$A14),--($B$2:$B$10=B$13),$C$2:$C$10)
Copy across and down

"Lynne" wrote:

Hi,
I have data as below and would like to know how to use a INDEX/MATCH to get
the summary captured in the summary below

A BOM 1
A BOM 2
A MAA 1
A BOM 4
A NWD 2
B BOM 1
B NWD 2
B NWD 1
B BOM 2


This should be summaried as follows:
BOM MAA NWD
A 7 1 2
B 3 3

Lynne