Formula of combining three rows and replace the 3 rows with the new row

[Kaustubh17]

Hi Team,

i have facing problem of solving the formula. i have 3 rows such as 

1   2   3

A -10-45

B-15-45

C-34-45

D-76-344

E-78-34

1,2,3 are fields and A to E are rows and in front of that we have data.

I want B+C+D which is Z now i don't want B,C,D row in the final output. i want the Z row with is Sum of B,C,D.

1  2    3

A-10-45

Z- Sum of B,C,D

E-78-24

if you have any doubt please let me know how i can resolve that.

Thanks,

Kaustubh

[binuacs]

@Kaustubh17 One way of doing this