Forum Discussion
Sum of merged cell
i have one merged cell corresponding to that i have 3 multiple cells with different values. I need sum of all the numbers which are there in multiple cells corresponding to that 1 merged cell. Kindly help
1 Reply
=NUMBERVALUE(INDEX(TEXTSPLIT($A$1,CHAR(10)),,ROW(B1)))+B1This works in my sheet. However i'd recommend to never work with merged cells.
