Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

A

B

C

D

1

P

X

1

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

Calc macro display
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")

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

2

2

4

2

3

3

2

3

4

4

4

4