Forum Discussion

littlevillage's avatar
littlevillage
Iron Contributor
Jan 09, 2023
Solved

Returned value in Merge Cells

Hi, How can write a formula to get the expected result like below: Thank you.  
excel
Formulas and Functions
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Jan 09, 2023

    littlevillage 

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

    A traditional formula would be

    = 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), "")
  )

     

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jan 09, 2023

littlevillage 

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

A traditional formula would be

= 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), "")
  )

 

Resources