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--
[TABLE="width: 500"]
<tbody>[TR]
[TD]rg no[/TD]
[TD]reg[/TD]
[TD]reg1[/TD]
[TD]count[/TD]
[TD]reg2[/TD]
[TD]count[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]zln[/TD]
[TD]zln[/TD]
[TD]60[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]tln[/TD]
[TD]tl[/TD]
[TD]30[/TD]
[TD]n[/TD]
[TD]60[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]tle[/TD]
[TD]tl[/TD]
[TD]30[/TD]
[TD]e[/TD]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]zle[/TD]
[TD]zl[/TD]
[TD]60[/TD]
[TD]e[/TD]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]tlatv/r[/TD]
[TD]tl[/TD]
[TD]30[/TD]
[TD]atv[/TD]
[TD]30[/TD]
[TD]r[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]zle[/TD]
[TD]zl[/TD]
[TD]60[/TD]
[TD]e[/TD]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD]aln50[/TD]
[TD]al[/TD]
[TD]180[/TD]
[TD]n50[/TD]
[TD]180[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]ale200[/TD]
[TD]al[/TD]
[TD]180[/TD]
[TD]e200[/TD]
[TD]45[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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...