| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Merged cells together
Hi there,
I am trying to sum the same cell in several worksheets. This I know how to do. My problem is the cell that I need to sum has been merged. When I try to sum these merged cells I get an error. Does anyone know how I can get around this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Merged cells together
Get rid off the merged cells. It caused more pain than good.
"Amie" wrote: Hi there, I am trying to sum the same cell in several worksheets. This I know how to do. My problem is the cell that I need to sum has been merged. When I try to sum these merged cells I get an error. Does anyone know how I can get around this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Merged cells together
What kind of error do you get? What's your formula look like?
I merged cells A1 & B1 on sheets 2 & 3. I entered this formula on sheet1: =SUM(Sheet2:Sheet3!A1) It returns the correct result. Biff "Amie" wrote in message ... Hi there, I am trying to sum the same cell in several worksheets. This I know how to do. My problem is the cell that I need to sum has been merged. When I try to sum these merged cells I get an error. Does anyone know how I can get around this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells are Merged. How to know where to where??? | New Users to Excel | |||
| Merged Cells | Excel Discussion (Misc queries) | |||
| how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
| Merged cells | Excel Discussion (Misc queries) | |||
| Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
Linear Mode
