Excel1: sum and if isnumber formula in merged cell.

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
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
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

Well-known Member
Joined
Mar 20, 2009
Messages
667
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
Code:
=IF(COUNT(B35,D35,F35,H35),SUM(B35:I35),"")

aacod
 

Watch MrExcel Video

Forum statistics

Threads
1,130,309
Messages
5,641,448
Members
417,209
Latest member
Agbarker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top