table summarisation

[ghoraisubha]

Hi,

I have the following Table( Very large)

A B C D
1 1
2 5
1 4
1
6 1
I want to summarise that like

A=8
B=2
C=6
D=6

Please help

[Glenn Kennedy]

...and how are the answers derived??!!!!!

How on earth do you get 8 from the data in column A, etc????

[Shareez Saleem]

As the total is 22, assumed the table looks like below:

A B C D
2 1 4 1
6 1 1 5
1

Please refer the attached sheet.


Use the formula CONCATENATE(A1,"=",SUM(A2:A4)), CONCATENATE(B1,"=",SUM(B2:B4)) etc. (copy & paste).

[ghoraisubha]

Actually it is a table but i am unable to make that in the post

A B C D
1 0 4 0
0 1 0 2
1 0 2 3
0 1 0 1
6 0 0 0

[ghoraisubha]

Not that i want ABCD in Col1& corresponding row & their sum in Col.2 in the corresponding row

Also i want the sum using total table using a single formula

[Shareez Saleem]

Please post a sample sheet and write your expected results manually.

[ghoraisubha]

File Attached. please help

[Naveed Raza]

Hi ghoraisubha

please find the attached file and have test and let me know is it what ur looking for.

hope this will work for u

Note: i save the file in (2010 version)

[ghoraisubha]

Thanks for the reply.

But i think below is the easy formula

=SUMPRODUCT(INDEX($A$3:$H$12,0,MATCH(J2,$A$2:$H$2,0)))

[Naveed Raza]

yes its will work, but only to fix rows from 3 to 12 rows only..

anyways u can use that function also

if you got the solution then please mar the thread as SOLVED and click on * to say thanks those who help you