 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Im just using a stock take gun and its scans items individualy which are then transfered to an excel spread sheets
As the items are scanned individualy the same code comes up with qty of 1 so is thatere a forumla that i can use to look at the 2 columns a deliver the total qty for each code?
2 coloums 1 Qty and 1 Code
Presumably some combination of COUNT and IF would be the crudest/simplest method?
SUMIF or SUMIFS will do the job, or just do a pivot table with code and sum of quantity
That'll be a job for the Pivot Table, unless you have a list of all the items you can put on a new sheet and use the COUNTIF function like Zokes suggested.
edit - damn, beaten to it while I was typing.
struggling with this guys just ried a couple of count if formulas but cant get it to work?
Bung it all in a pivot table, it will give you he sum by product code
Pivottable ftw
ta pivot table 2 secs worked great thanks guys
OK, this is the way I'd do it with the COUNTIF function, but I think a Pivot Table would be better.
Start a new sheet (Sheet 2), and put a list of all the individual items you have in stock in column A. For this next bit I'll assume your original sheet is called Sheet 1 and the list of items you have scanned is in column A.
In Sheet 2, cell B1 type: =COUNTIF(Sheet1!A:A, A1)
This counts all of the times the stock item in Sheet 2, cell A1 matches the text in Sheet 1 column A.
Drag the formula down to sheet 2 cell A2, A3 A4 etc.
Dun.
edit - I really need to improve my typing speed. 🙂