Forum Discussion
Inventory Formula w/two lists
Hello Excel Jedi’s, I’m hoping somebody can help with what I thought would be an easy solution. I have a master spreadsheet listing UPC numbers. I’m able to barcode scan numbers into excel but c...
=SUM(COUNTIF('Master spreadsheet'!$B$2:$B$27,$A$2:A2))You can try the example in the attached file. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.