example: Use sheet reference




12
34






56sum(a1:b1) + sum(1!a1:b1)

78sum(a2:b2) + sum(1!a2:b2)

  • sum(1!a1:b2) → 

  • sum(2!a1:b2) → 

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