Morning,

I have got three reference numbers in cells B2 to B12, 1740, 1741 & 1742. So
in cells B2, B4, B7, B8 there is 1740. In cells B3, B9, B10 & B12 is 1741,
then in cells B5, B6 & B11 is 1742.

In cells C2 to C12 is volumes per reference number.

I want a formula to put the three reference numbers in cells E2 to E4 and
then I would sumif the volumes to its respective reference number.

I am looking for a formula to work like a pivot table, but need to keep the
file size small, thus looking for a formula instead.

Thanks