Summing with condition and loop

[bestnagi]

I have an excel sheet with 3 columns.
Column1 is ClientName, column2 is Desrciption , column 3 is a number corresponding to the description.
I need to sum the numbers corresponding to each description of ClienName using filters or for loop.
In other words:

<code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">col1 col2 col3
Jason Cash 20
Jason Cash 30
Jason Cash 10
Jason Credit 20
Jason Credit 40
John Cash 20
John Cash 10
John Credit 30
John Credit 20
Mary Cash 50
Mary Cash 20
Mary Credit 20
Mary Credit 100
Mary Credit 200
</code>
I need results like that

<code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">Jason CashTotal CreditTotal
John CashTotal CreditTotal
Mary CashTotal CreditTotal
</code>
How can this be done in Excel?

 

[Yahya]

F2 = Jason G2 = Cash
H2 =SUMPRODUCT(--($A$2:$A$15=F2),--($B$2:$B$15=G2),$C$2:$C$15)
and list other conditions under coloumn F and G

 

[Trevor G]

Welcome to the forum, you could use either SUMIFS or SUMPRODUCT dependant on the version of Excel you are using, the sample below is using SUMPRODUCT

Excel Workbook
	A	B	C	D	E	F	G
1	col1	col2	col3			Cash	Credit
2	Jason	Cash	20		Jason	60	60
3	Jason	Cash	30		Jason	60	60
4	Jason	Cash	10		John	30	50
5	Jason	Credit	20		Mary	70	320
6	Jason	Credit	40
7	John	Cash	20
8	John	Cash	10
9	John	Credit	30
10	John	Credit	20
11	Mary	Cash	50
12	Mary	Cash	20
13	Mary	Credit	20
14	Mary	Credit	100
15	Mary	Credit	200
Sheet2

 

[eblake]

F2 = Jason
F3 = John
F4 = Mary

G2 (copied down) =SUMIFS($C$2:$C$15,$A$2:$A$15,$F2,$B$2:$B$15,"Cash")
H2 (copied down) =SUMIFS($C$2:$C$15,$A$2:$A$15,$F2,$B$2:$B$15,"Credit")

 

[bestnagi]

Thanks a lot for the quick answers. It worked using both methods.