Sum of multiple tables data

[meetvivek72]

well, all i need is the sum of all values of nucleotides A G T C & N at the end of the table,


Actually i have a huge size file(cant attach here) which includes many tables may be in thousands.
Each table has three fields i.e. nucleotide, Number & Mol. The values are also given against each nucleotide as u can see it from table. All i need is the sum of the values from Number column for A G C T & N, it would be something like this :
I am displaying here only for A , but it should show the sum for others(GCTN) too

Nucleotide Number Mol
A 7727 (3044+1652+1651+1380)

i need only the sum 7727 in Number field not (3044+1652+1651+1380)etc.....

here is the table description
[TABLE="width: 262"]
<colgroup><col style="width: 262pt; mso-width-source: userset; mso-width-alt: 12430;" width="350"> <tbody>[TR]
[TD="width: 350, bgcolor: transparent"]DNA molecule: Contig1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Length = 10221 base pairs[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Molecular Weight = 3117106.00 Daltons, single stranded[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Molecular Weight = 6206947.00 Daltons, double stranded[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]G+C content = 45.48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A+T content = 52.90[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Nucleotide Number Mol[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] A 3044 29.78[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] C 2452 23.99[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] G 2196 21.49[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] T 2363 23.12[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] N 166 1.62[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DNA molecule: Contig2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Length = 6218 base pairs[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Molecular Weight = 1883258.00 Daltons, single stranded[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Molecular Weight = 3774966.00 Daltons, double stranded[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]G+C content = 43.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A+T content = 52.91[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Nucleotide Number Mol[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] A 1652 26.57[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] C 1240 19.94[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] G 1460 23.48[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] T 1638 26.34[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] N 228 3.67[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DNA molecule: Contig3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Length = 6626 base pairs[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Molecular Weight = 2009275.00 Daltons, single stranded[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Molecular Weight = 4020750.00 Daltons, double stranded[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]G+C content = 40.79[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A+T content = 53.70[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Nucleotide Number Mol[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] A 1651 24.92[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] C 1404 21.19[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] G 1299 19.60[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] T 1907 28.78[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] N 365 5.51[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DNA molecule: Contig4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Length = 5410 base pairs[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Molecular Weight = 1640620.00 Daltons, single stranded[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Molecular Weight = 3288155.00 Daltons, double stranded[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]G+C content = 47.76[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A+T content = 49.15[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Nucleotide Number Mol[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] A 1380 25.51[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] C 1174 21.70[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] G 1410 26.06[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] T 1279 23.64[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] N 167 3.09[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 349"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]