SOLVED

# Returned value in Merge Cells

Frequent Contributor

# Returned value in Merge Cells

Hi,

How can write a formula to get the expected result like below:

Thank you.

3 Replies
best response confirmed by small_village (Frequent Contributor)
Solution

# Re: Returned value in Merge Cells

I would forget about the merged cells.  They will be too much trouble to maintain.

``````= IF(\$A2<>\$A1,
SUMIFS(\$B\$2:\$B\$14, \$A\$2:\$A\$14, \$A2),
"")``````

and drag down.  The orange is pretty but I wouldn't use the formula, instead with 365

``````= LET(
priorMVD, DROP(VSTACK("",MVD),-1),
newMVD?,  MVD<>priorMVD,
IF(newMVD?, SUMIFS(Unit, MVD, MVD), "")
)``````

# Re: Returned value in Merge Cells

This is without the merged cells.

# Re: Returned value in Merge Cells

if merge cell not easy by formula,try this online tool。

http://e.anyoupin.cn/ceshi/jstest/pull_up_demo.php?s=return_sum_group_by_in_merge

MVĐ Unit Expected result
237I51 100000 450000
237I51 200000
237I51 150000
237I52 400000 1100000
237I52 500000
237I52 100000
237I52 100000
237I53 200000 2500000
237I53 300000
237I53 400000
237I53 500000
237I53 600000
237I53 500000