Add same value of a column

Solved/Closed
Banti - Feb 16, 2011 at 02:31 AM
 Banti - Feb 17, 2011 at 08:40 AM
I have two columns A & B like this
A B
32 7000
33 8000
32 9000
33 6000
39 10000 and so on, I would like to get in columns C & D like this
C D
32 16000
33 14000
39 10000 how to do plz guide

2 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Feb 17, 2011 at 05:59 AM
introduce a heading row in row no. 1
highlight data columns A and B with header row . sort according to column A
still highlighting the data with header row click data-subtotal

the subtotal window is interactive

the data will look like thsi

hdng1 hdng2
32 7000
32 9000
32 Total 16000
33 8000
33 6000
33 Total 14000
39 10000
39 Total 10000
Grand Total 40000
0
How it was easy isn't it but after your reply. Thank you Venkat Sir
0