I want to create a spreadsheet for tracking stock levels. I will be using a barcode scanner to enter various part numbers of which I want to track the totals.
I have started with a SUM IF formula but wondered if there was a way of simplifying this as there may be quantities of up to 30 to be added for a range of different parts.
The formula I have started with to allow up to a quantity of 5 items is:

=SUM(IF(N1:N106=”xxxxx”,1,0),(IF(N1:N106=”xxxxx5″,5,0)),(IF(N1:N106=”xxxxx4″,4,0)),(IF(N1:N106=”xxxxx3″,3,0)),(IF(N1:N106=”xxxxx2″,2,0)))

xxxxx is a part number and I would need a similar formula for all part numbers.

*2,*3 etc allows the operator to change the quantity rather than scan each individual item.
I hoped the variable quantity could be included in the formula without having to create a separate statement for each possible number.