Forum Discussion
Solved
Sumif inside Xlookup
Can someone tell me how to sum within Xlookup please? Correct answer above would have been 65+5=70. I am looking for total qty, if part is "F" and Location is "OM". Main Table has two match...
Thank you. Sumproduct did not work but filter function formula above worked. Thanks again.
It works. Thank you.
SUMPRODUCT() definitely works, but SUMIFS() could be bit easier