View Source

1

2

sum(a1:b1)

sum(a1:b1)

3

4

sum(a2:b2)

sum(a2:b2)

5

6

sum(a1:b1)

sum(a1:b1)

7

8

sum(a2:b2)

sum(a2:b2)

sum(1!d1:d2) + sum(d1:d2)

sum(1!d1:d2) + sum(d1:d2)

sum(1!d1:d2) →

sum(1!d1:d2)

sum(1!a1:b2) + sum(2!a1:b2) →

sum(1!a1:b2) + sum(2!a1:b2)