Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding cells in different work sheets
Hi
I would like to know how do you add certain cells in different worksheets when they are not identical sheets. For example, I am adding up totals in all the sheets, but the total cell is in a different place in each sheet. |
#2
|
|||
|
|||
adding cells in different work sheets
best to put in the same place and us
=sum(sheet1:sheetfinal!a1) or =sheet1a2+sheet2!a6 etc -- Don Guillett SalesAid Software "dmedina" wrote in message ... Hi I would like to know how do you add certain cells in different worksheets when they are not identical sheets. For example, I am adding up totals in all the sheets, but the total cell is in a different place in each sheet. |
#3
|
|||
|
|||
adding cells in different work sheets
To access different sheets in the same workbook use this format. This
function adds cells A4 from Sheet1 and A3 from Sheet2. =Sheet1!A4+Sheet2!A3 "dmedina" wrote: Hi I would like to know how do you add certain cells in different worksheets when they are not identical sheets. For example, I am adding up totals in all the sheets, but the total cell is in a different place in each sheet. |
#4
|
|||
|
|||
adding cells in different work sheets
This worked out great for me, thanks.
"Sloth" wrote: To access different sheets in the same workbook use this format. This function adds cells A4 from Sheet1 and A3 from Sheet2. =Sheet1!A4+Sheet2!A3 "dmedina" wrote: Hi I would like to know how do you add certain cells in different worksheets when they are not identical sheets. For example, I am adding up totals in all the sheets, but the total cell is in a different place in each sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding cells after stripping numbers out of text fields | Excel Discussion (Misc queries) | |||
Tab key don't work in unprotected cells in a protected sheet | Excel Discussion (Misc queries) | |||
Find values from cells in multiple sheets | Excel Worksheet Functions | |||
Pie Diagram from data across multiple work sheets | Charts and Charting in Excel | |||
Adding contents of one cell to a range of cells. | Excel Worksheet Functions |