Auto Add

[richardplr]

Dear All

I would like to know is it possible to auto add up the quantity, everytime I
use my barcode scanner scan up the same barcode no.

Example: I have few sample items with same lot no. when I do stock take, I scan all the items and if I scan with the same lot number, it will add up to show 1 and if i scan the same lot no again, this time is give me 2 etc.

Please advise is this possible.

Thank you and awake your kind reply

Regards,

 

[oldaf294]

richard,
Enter in column "B", next to your barcode column, if it is "A";
=COUNTIF($A$2:$A$25,A2)
Where $A$2:$A$25 is the range of your barcode column, it will count the number of instances of the barcode.
I forgot to add, it will give the total for each instance of the barcode.
jim