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

Day Amount Means 1 143 Bank 2 22 Cash 3 1980 Master Card <tbody> </tbody> 4 5 Debt Card 5 388 Master Card <tbody> </tbody> <tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

And I want it to be summarized in the following table

Means <tbody> </tbody>	Total <tbody> </tbody>
Bank
Cash
Master Card
Master Card <tbody> </tbody>

<tbody>
</tbody>

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;">

Cash

<tbody>
</tbody>

</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.