Adding Merged cells together

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top