On May 4, 11:37 am, "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

I think index and match won't work since you need to sum. Use sumif
function for A row and as range select data from A rows above and then
make another sumif for B row with a range selecting data rows for B.

For example if your first A is in A1 then function to calculate 7 for
A / BOM would be B11 = SUMIF(B1:B5;B10;C1:C5)

Mitja