Please help

[naf80]

Hi everyone,

I am happy to join to such wonderful forum. I will really appropriated if you could help this issue. I have the following table[TABLE="width: 90"]
<colgroup><col></colgroup><tbody>[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]Day[/TD]
[TD]Amount[/TD]
[TD]Means[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]143[/TD]
[TD]Bank [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]22[/TD]
[TD]Cash[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1980[/TD]
[TD][TABLE="width: 90"]
<tbody>[TR]
[TD]Master Card[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]5[/TD]
[TD]Debt Card[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]388[/TD]
[TD][TABLE="width: 90"]
<tbody>[TR]
[TD]Master Card[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

And I want it to be summarized in the following table
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 90"]
<tbody>[TR]
[TD="class: xl126, width: 90"]Means[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl126, width: 70"]Total[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Bank [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cash[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Master Card[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 90"]
<tbody>[TR]
[TD]Master Card[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

such that the Total will be reading from the first table ans sort by mean. I want
the bank in 2nd table = 143 and the Master Card = 1980+388

Thank you very much in advance>

****** id="cke_pastebin" style="position: absolute; top: 292px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]Cash[/TD]
[/TR]
</tbody>[/TABLE]
</body>

 

[jtakw]

Hi,

SUMIF should do it:

Book1
	A	B	C	D	E	F
1	Day	Amount	Means		Means	Total
2	1	143	Bank		Bank	143
3	2	22	Cash		Cash	22
4	3	1980	Master Card		Master Card	2368
5	4	5	Debt Card		Debt Card	5
6	5	388	Master Card
Sheet1

Cell Formulas
Range	Formula
F2	=SUMIF(C$2:C$6,E2,B$2:B$6)

F2 formula copied down, change cell references as needed.

 

[MARK858]

I am now Interpreting the question differently, when I first read it I also thought it was just a sumif but now not so sure (mainly because of the 2 Master cards in the 2nd Table) so just in case...

Excel Workbook
	A	B	C	D	E	F	G	H
1	Day	Amount	Means				Result 1	Result 2
2	1	143	Bank		1.000002	1	Bank	143
3	2	22	Cash		2.000003	2	Cash	22
4	3	1980	Master Card		5.000004	4	Debt Card	5
5	4	5	Debt Card		3.000005	3	Master Card	1980
6	5	388	Master Card		5.000006	5	Master Card	388
Sheet2

 

[naf80]

Thank you very much. you guys are the best.

 

[jtakw]

You're welcome, welcome to the forum, Happy New Year.