Hello

I have a spreadsheet that requires information to be copied from one selection of merged cells to another (located on a separate worksheet). This is a simple process (if you are using single cells), as you would just use a formula to populate one cell with the value of another. However the cells that I am trying to populate are a combination of four separate cells (now merged into one), and as such, I am finding that any kind of formula (i.e. sum, average, count.....) does not work with merged cells.

Is this a characteristic of Excel, or is there a way of getting standard excel formula to work on merged cells, as it does on single cells?

Many thanks for any help

Cheers
G1