How to sync between two columns and present the number of times value appears on the colum

Dear Pros, I would appreciate your assistance in finding the right formula.

Ok, the topic might be hard to understand but i'll try to do it as easy as possible ( I have attached the file) .
I have a list of codes on a-d , everytime I go to my storage I am scanning with my phone all the barcodes of the new items that arrived to the storage.
I export the scanned barcodes from my phone to excel and copy the column of the codes to my main list (column G) .
How do I add up the scanned codes from G to column E of Total items? ( i believe I need to add a combination of vlookup and sum but I have no idea how) .
8WrY2aK.jpg
Thanks in advance

Ok, I found the solution by adding to the COUNTIF range the $ sign to keep the same range.
My question is , how can I keep the value if I wanna delete the SCAN BARCODE column and on the next time to add another list of scanned barcodes to the total that I had before .

=countif($o$2:$o$200;i2)

Based on the information supplied:-
1. There are no duplicates in column B
2. There are no duplicates in column C
3. There are no duplicates in column D
4. There are a number of duplicates in column G

Of the 11 barcodes in column G :-
3 are already in columns B and C (and have unique item codes)
11 are not in columns B or C (and do not have unique item codes)

Do these 11 need to be added to columns B and C in order to have a correct count in column E?

See attached.

regards

peterrc

Originally Posted by etaf

OK
or you could use
=countif(o:o;i2)

then the range will not matter when you put the new values into the sheet column I

Ok, I guess i'll just have to delete the items from i when they are being sent out of the storage...

Originally Posted by peterrc

regards

peterrc

Sorry I think you misunderstood what i'm trying to make.
the all point of the excel file is to try an efficient way to organize my storage.