Please help

naf80

New Member
Joined
Jan 1, 2018
Messages
2
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>
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Hi,

SUMIF should do it:


Book1
ABCDEF
1DayAmountMeansMeansTotal
21143BankBank143
3222CashCash22
431980Master CardMaster Card2368
545Debt CardDebt Card5
65388Master Card
Sheet1
Cell Formulas
RangeFormula
F2=SUMIF(C$2:C$6,E2,B$2:B$6)


F2 formula copied down, change cell references as needed.
 
Upvote 0
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
ABCDEFGH
1DayAmountMeansResult 1Result 2
21143Bank1.0000021Bank143
3222Cash2.0000032Cash22
431980Master Card5.0000044Debt Card5
545Debt Card3.0000053Master Card1980
65388Master Card5.0000065Master Card388
Sheet2
 
Upvote 0
You're welcome, welcome to the forum, Happy New Year.
 
Upvote 0

Forum statistics

Threads
1,224,880
Messages
6,181,532
Members
453,054
Latest member
ezzat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top