Here is my Formula...
=IFERROR(SUMIFS(SGReport!E:E,SGReport!L:L=[@[Product List]],SGReport!K:K=ArrayData!E5),TRUE),"Didn't Work")
is not working but it seems correct. I am looking to Sum if you find the condiction is true
If colu L:L matches @ Prodcut list and if in colum K:K matches E5 then add the numbers in colum E:E
~J
Bookmarks