aacod
Well-known Member
- Joined
- Mar 20, 2009
- Messages
- 667
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
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