Say in cols A thru C:

1 q q
2 q q
3 q q
4 q q
5 x q
6 x y
7 x y
8 x y
9 x q
10 x q
11 x z
12 x z
13 x z
14 x q
15 x q
16 q q
17 q q
18 q q
19 q q
20 q q

and we want to sum col A for col B="x" and col C="y" or "z"

=SUMPRODUCT(A1:A20,--(B1:B20="x"),--(C1:C20="y"))+SUMPRODUCT(A1:A20,--(B1:B20="x"),--(C1:C20="z"))

will give 57
--
Gary''s Student - gsnu200791


"PBcorn" wrote:

need to sumif or sumproduct based on text values in two columns:

so:

sum values in sumrange if col1 value= "x" AND col2 value = ("y" OR "z")

please advise