M
Melody
I need a formula: If (C1:C10=A1) and (D1
10 or E1:E10=B1) then Sumproduct F1:F1
Thanks for your help in advance.
10 or E1:E10=B1) then Sumproduct F1:F1Thanks for your help in advance.
F
Frank Kabel
Hi
try
=SUMPRODUCT((C1:C10=A1)*((D110=B1)+(E1:E10=B1)>0),F1:F10)
try
=SUMPRODUCT((C1:C10=A1)*((D1
10=B1)+(E1:E10=B1)>0),F1:F10)
P
Peo Sjoblom
=SUMPRODUCT(--(C1:C10=A1),--(D110=B1),F1:F10)
10=B1),F1:F10)
F
Frank Kabel
Hi Peo
think you just overread the OR condition
think you just overread the OR condition
P
Peo Sjoblom
Sorry, didn't catch the OR part, see Frank's answer
M
Melody
Got it, and it worked. Thanks for your help.