Sum cells in one column using values of equal sized merged cells in another column

[sushil985]

Hi ..
Please help me with a formula which adds values of column VALUES depending on the MERGED column .. i am trying to use sumif but this takes the merged cells as only the first cell. Each merged cell is 4 rows . i know that this can easily be done in vba but i am trying to figure out a way using formulae.

 

[DILIPandey]

Hi Sushil,

Merging is a disease for excel.
I would suggest you to unmerge or use a helper column.

suppose you have merged data in F6:F9, then use enter
below formula in E6:-
=F6
below formua in E7:-
=IF(F7=0,E6,F7)
and drag down till E9.

Now you have unmerged data in column E, using which you can do sumif.


Regards,
DILIPandey