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