using sumif function to sum up values

[drkiran33]

hello,

I am here to have a solution to a problem to sumup the data.my question is--

rg no	reg	reg1	count	reg2	count
1	zln	zln	60
11	tln	tl	30	n	60
2	tle	tl	30	e	30
4	zle	zl	60	e	30
5	tlatv/r	tl	30	atv	30	r	30
4	zle	zl	60	e	30
36	aln50	al	180	n50	180
7	ale200	al	180	e200	45

<tbody>
</tbody>

My data is arranged like this.so i need to add individually,ie.,for each zln,zl,tl,n,e,n50,e200, seperately, like this

zln=60,
tl=90,
zl=120,
al=360
n=60,
e=90
n50=180
e200=45
r=30
atv=30
Thanks in advance.

 

[BGY23]

Lets assume yoor data is in A1 to F9
Lets assume your summary list is in A15 to A25

Then In B15 key =sumif($c$2:$C$9,A15,$D$2:$D$9)+=sumif($E$2:$E$9,A15,$F$2:$F$9)

Copy down to get all values

 

[drkiran33]

Thank you very much,i made some correction to include the third segment and removed =,
again...thank you so much...