Hello,

I want to have my sum if check two variables before it outputs the result.

So I need to check

1. Col A7 in book 1 to Col A2:A400 in book 2, and
2. Col E7 in book 1 to Col B2:B400 in book 2, then
3. Output my quanitity or Col G2:G400 in book 2 in book 1 where I am running
the formula.

Any help greatly appreciated

The reason for the sumif is that there might be multiple entries of the same
name and I want a combined value instead of a each single entry.

Thank you