View Source

A

B

C

D

1

P

X

1

formula: SUMIFS(C1:C4, A1:A4, "Q", B1:B4, "X")

SUMIFS(C1:C4, A1:A4, "Q", B1:B4, "X")

2

P

Y

2

3

Q

X

3

4

Q

Y

4

A

B

C

D

1

1

2

1

formula: SUMIFS(C1:C4, A1:A4, ">1", B1:B4, "==2")

SUMIFS(C1:C4, A1:A4, ">1", B1:B4, "==2")

2

2

4

2

sum(a1,b2)

sum(a1,b2)

3

3

2

3

4

4

4

4