example: Use sheet reference 2
- Support@Kenputer
- Anonymous
Owned by Support@Kenputer
| 1 | 2 | sum(a1:b1) |
|
| 3 | 4 | sum(a2:b2) |
|
| 5 | 6 | sum(a1:b1) |
|
| 7 | 8 | sum(a2:b2) |
|
| sum(1!d1:d2) + sum(d1:d2) |
|
sum(1!d1:d2) → sum(1!a1:b2) + sum(2!a1:b2) →
| 1 | 2 | sum(a1:b1) |
|
| 3 | 4 | sum(a2:b2) |
|
| 5 | 6 | sum(a1:b1) |
|
| 7 | 8 | sum(a2:b2) |
|
| sum(1!d1:d2) + sum(d1:d2) |
|
sum(1!d1:d2) → sum(1!a1:b2) + sum(2!a1:b2) →