=SUMIF(Table3[@[Part Number]],Table3[@[Part Number]],Table3[@Qty])
I want to sum all the qty of the same part number, so there is 1 entry in my other table regardless of how many times it is entered in Table3.
I have seen this working on youtube videos but it doesnt work for me.
When i get to the table i see seperate entries for the same part number table on (Stock On Hand)
Any help would be appreciated
Bookmarks