Forum Discussion

Brass Contributor

Mar 19, 2026

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...

Formulas and Functions

rossshah
Mar 19, 2026
Thank you. Sumproduct did not work but filter function formula above worked. Thanks again.

m_tarler

Bronze Contributor

Mar 19, 2026

I suggest you just use FILTER or SUMPRODUCT instead. Here are a couple examples that should work:

=SUM(FILTER(C:C, (A:A=$E$2)*(B:B=E6), 0) )

=SUMPRODUCT( (A:A=$E$2)*(B:B=E6)*(C:C) )

rossshah

Brass Contributor

Mar 20, 2026

Thank you for helping me. All three formulas worked except for the one with additional "." in front.

Following formula is the one that did not work.

=SUMPRODUCT( A2:.A99=$E$2)*(B2:.B99=E6)*(C2:.C99))

But I have three formulas returning the correct value. Thanks again.

m_tarler
Bronze Contributor
Mar 20, 2026
you're welcome. Somehow I dropped a ( it should be:
=SUMPRODUCT( (A2:.A99=$E$2)*(B2:.B99=E6)*(C2:.C99))
I corrected it in the message below also
- rossshah
  Brass Contributor
  Mar 20, 2026
  It works. Thank you.
  - SergeiBaklan
    Diamond Contributor
    Mar 21, 2026
    SUMPRODUCT() definitely works, but SUMIFS() could be bit easier