Sum of particular series in Table

[vijayca]

Dear All,

I need to get the sum of GL code starting from 4 series. Example is given below

GL CODE 1100000000
10300000 85
10300100 10
10308000 12
10311000 16
10313000 5
41130230 5
41130250 5
41130260 5
41210000 5
41300100 5
10400000 5
10405000 6
10405010 19
10500000 12
10600010 16
10600100 15
Total 226

SUM of 4 Series only 25

Thanks in Advance

[AlKey]

Try this

Please Login or Register  to view this content.

Or better this

Please Login or Register  to view this content.

v	A	B	C	D
1
2	10300000	85		25
3	10300100	10
4	10308000	12
5	10311000	16
6	10313000	5
7	41130230	5
8	41130250	5
9	41130260	5
10	41210000	5
11	41300100	5
12	10400000	5
13	10405000	6
14	10405010	19
15	10500000	12
16	10600010	16
17	10600100	15