Easy Excel Question
Discussion
in the cell in the sheet you want the answer type:
=SUM(
and then go to each sheet and click the cell you want including in the answer whilst holding down Control as you go
when finished release control and you'll return to your cell with the =sum(.....
add the final ) and hit return.
that should sort it for you
^^^^^^^^^^
was bolloxs - as control should be the SHIFT key and all you need do after selecting the first cell of the sum is click on the tabs whilst holding shift.
FG
=SUM(
and then go to each sheet and click the cell you want including in the answer whilst holding down Control as you go
when finished release control and you'll return to your cell with the =sum(.....
add the final ) and hit return.
that should sort it for you
^^^^^^^^^^
was bolloxs - as control should be the SHIFT key and all you need do after selecting the first cell of the sum is click on the tabs whilst holding shift.
FG
Edited by FunkyGibbon on Monday 30th April 16:23
FunkyGibbon said:
in the cell in the sheet you want the answer type:
=SUM(
and then go to each sheet and click the cell you want including in the answer whilst holding down Control as you go
when finished release control and you'll return to your cell with the =sum(.....
add the final ) and hit return.
that should sort it for you
^^^^^^^^^^
was bolloxs - as control should be the SHIFT key and all you need do after selecting the first cell of the sum is click on the tabs whilst holding shift.
FG
=SUM(
and then go to each sheet and click the cell you want including in the answer whilst holding down Control as you go
when finished release control and you'll return to your cell with the =sum(.....
add the final ) and hit return.
that should sort it for you
^^^^^^^^^^
was bolloxs - as control should be the SHIFT key and all you need do after selecting the first cell of the sum is click on the tabs whilst holding shift.
FG
Edited by FunkyGibbon on Monday 30th April 16:23
lovely, that worked a treat!!!
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff