Excel1: sum and if isnumber formula in merged cell.

[aacod]

I have following:

Cells B35, B36, C35 & C36 merged & centered.
Cells D35, D36, E35 & E36 merged & centered
Cells F35, F36, G35 & G36 merged & centered
Cells H35, H36, I35 & I36 merged & centered

I want a Sum formula in cell J35, J36, which are merged and centered, such that if there is a number in any of the above merged cell put the total or leave blank.

Thanks.

aacod

 

[Dryver14]

I would unmerge these cells

If you want he information to show accross the cells then highlight the cells, go to format cells and select the alignment tab,

on the horizontal drop down select center accros selection,

This way if you center from A1 to A3 then anyformulas can refer to A1

 

[aacod]

Dryver14,

Thanks for your input, but if I have to delete a figure than I have to go to that particular cell, while if the cells are merged, delete becomes simple. I used following formula in J35, J36

=IF(COUNT(B35,D35,F35,H35),SUM(B35:I35),"")

aacod