example: Use sheet reference
1 | 2 |
3 | 4 |
5 | 6 | sum(a1:b1) + sum(1!a1:b1) |
|
7 | 8 | sum(a2:b2) + sum(1!a2:b2) |
|
sum(1!a1:b2) →Â
sum(2!a1:b2) →Â
sum(1!a1:b2) + sum(2!a1:b2) →Â
1 | 2 |
3 | 4 |
5 | 6 | sum(a1:b1) + sum(1!a1:b1) |
|
7 | 8 | sum(a2:b2) + sum(1!a2:b2) |
|
sum(1!a1:b2) →Â
sum(2!a1:b2) →Â
sum(1!a1:b2) + sum(2!a1:b2) →Â