Help with Countif and VLOOKUP


I have a spreadsheet with 3 columns

Column A has barcode Numbers

Column B has the product name

Column C has the product QTY amount

I like to scan a barcode in column A starting at the 2nd row and if the barcode is listed in column A it will increase the QTY number by one in the correct barcode row in Column C.

I also like if the barcode is already listed in Column A is will not list it. (It will do nothing).  I will just scan the next barcode.

The formula I have in Column C is “=COUNTIF(A2:A10,A2)”

I will send you my spreadsheet to show you what I have so far.

By: Derrell Dulin

Leave a Reply

Your email address will not be published. Required fields are marked *