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