Easy Excel Question

[greg_D]

As with most things in life, it is easy if you know the answer, and presently i don't, hopefully one of you lot will!!!!!!

on excel, i need to add up the contents of the same cell in multiple tabs (ie a summary of numerous pieces of data) how do i do it?

Greg

[FunkyGibbon]

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

Edited by FunkyGibbon on Monday 30th April 16:23

[greg_D]

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

Edited by FunkyGibbon on Monday 30th April 16:23

lovely, that worked a treat!!!