Sumif

[Guest]

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

 

[Guest]

Mirko -- Here's a place where the =SUMPRODUCT function works slick. As
follows:

1 2
A Fred 1
B Joe 2
C Fred 3
D Joe 4
E Sam 5
F
G Fred =SUMPRODUCT(--($A$1:$A$5=G1),$B$1:$B$5
H Joe copy down

How it works -- if the value in the 'A' column equals the test value (in
this case, Fred) it assigns a value of '1' and multiplies it by the value in
the second column, and summing the results. You can do this (carefully!)
with multiple criteria.

HTH.

 

[Peo Sjoblom]

In this case there is no need to use SUMPRODUCT

=SUMIF($A$1:$A$5,G1,$B$1:$B$5)

will suffice