Multiplication of values in same row if condition is met

Hello there,

i would like to have excel compute a sum of a previous multiplication of values which are in different columns but in the same row if in the very same row there is for example A1="string1" and B1="string2". that shud be performed over for example row 1 till row 2000...

can this be done via a simple excel formula? i already tried sumifs and sumproduct but that didnt work out so far.

thanks very much for your help!

what i actually tried is this: SUMPRODUCT( (DATA III!$A$3:$A$2000="ST220") * (DATA III!$B$3:$B$2000="220R1") * (DATA III!$C$3:$C$2000="GW1") * (DATA III!$P$3:$P$2000) * (DATA III!$R$3:$R$2000))

this however returned a #name? error...

thanks for the quick response! i tried that out but that doesnt help! excel infact removes the ' ' automatically so it looks like before...

SUMPRODUCT('DATA III'!$A$3:$A$2000="ST220", 'DATA III'!$B$3:$B$2000="220R1", 'DATA III'!$C$3:$C$2000="GW1", 'DATA III'!$P$3:$P$2000, 'DATA III'!$R$3:$R$2000) i now substituted the * by , and i got rid of the error. now however the formula returns 0, does anyone have an idea as to why this could happen? i know that there are exactly 4 lines in this DATA III sheet where the conditions are met but it seems no suming up of the multiplied values takes place....

OMG, you are a genius!!! the -- before the string conditions did the trick!! thanks so much! so now my only question is, why was excel not smart enough to do without the -- and what does the -- actually do?

oh ok this seems very useful! i assumed a true or false would be treated as 1/0 automatically in a multiplication...