Sumif
In this case there is no need to use SUMPRODUCT
=SUMIF($A$1:$A$5,G1,$B$1:$B$5)
will suffice
--
Regards,
Peo Sjoblom
"pdberger" wrote in message
...
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.
"Mirko" wrote:
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
|