Does anyone know why the equation =SUM(Sheet52:Sheet1!B9) wouldn't work? Or anything else I could try?
2007-01-08 11:59:21 · 2 answers · asked by ice_purple969 4 in Computers & Internet ➔ Software
Hi .. the equation u r using =Sum(CellX:CellY) will try to get u the sum of the content of all the cells between CellX and CellY..
Not sure if it will work on two different Sheets, but notice that u specifide Cell B9 in sheet 1 .. where in Sheet 52 u didn't ..
You are doing something wrong there for sure .. if u would provide mroe details about the cells u want to sum .. so i can tell u what to do exactly. you can IM me and i could help u online
take care
2007-01-08 12:10:05 · answer #1 · answered by KickBoxer 3 · 0⤊ 0⤋
It looks like the first sheet you are referencing is lacking a cell designation (a letter/number combo after the !)
I'm also not even sure if you can define a range between multiple sheets.
But if you just want to add two cells (on different pages) you would use =(Sheet52!B4)+(Sheet1!B9)
(for example)
2007-01-08 20:08:44 · answer #2 · answered by seweccentric 5 · 1⤊ 0⤋