how do I add cells on different worksheets in excell
 

Having trouble adding same cell on different worksheets can anyone help

how do I add cells on different worksheets in excell
 

If the sheets you want to include are in a contiguous group:

=SUM(Sheet1:Sheet5!A1)

If the sheets are random:

=SUM(Sheet1!A1,Sheet5!A1,Sheet7!A1)

--
Biff
Microsoft Excel MVP


"reidser" wrote in message
...
Having trouble adding same cell on different worksheets can anyone help

how do I add cells on different worksheets in excell
 

I am not really sure what exactly do you mean but if you mean that you want
to add a column or a row in the same place in several sheets you should
active the place that you want to add row or column in the first sheet and
then press Ctrl and hold it and click on the other sheets that you want to
add and then go to menu: Insertrows or columns.

Hope this works for you otherwise you gotto give more explanation.
--
Farhad Hodjat


"reidser" wrote:

Having trouble adding same cell on different worksheets can anyone help