I think for you will work:
1. Rename column headings so they are without spaces (it's optional)
Container.Name > Container
Lot.ID/Lot_ID > Lot
Price Point > PricePoint
2. Define names
nStore = DestinationSheet!$B$2
nPricePoint = DestinationSheet!$A$13
3. Define both tables on sheet 'Picklist By Individual Unit Qty' and 'DestinationSheet' as Tables, p.e. tSource and tDestination
The table formula will be probably (I'm not fully sure how did you calculate row numbers in column B of source sheet)
Code:
=SUMIFS(tSource[PricePoint],tSource[Store],nStore, tSource[Container], [@Container], tSource[Lot], [@Lot], tSource[PricePoint], nPricePoint]
In case you don't want to use Table formula, you have to replace all column references with absolute references, row references with dynamic references [and names with absolute references].