Hi Steve
Im a little confused as to what i should use as the range and criteria when im using SumIF
this is the list that i have;
Code Qty
M/A/012 2
M/A/07 4
M/A/12 89
M/B/01 6
M/B/02 1
M/B/04 4
M/B/07 1
M/B/10 3
M/B/12 4
M/B/13 25
M/B/13 1
M/B/17 3
M/B/18 8
M/I/10 2
M/I/13 5
M/I/14 1
M/S/07 14
M/S/18 6
M/S/12 12
M/S/18 2
M/S/20 5
M/S/21 11