# Sum By 1 Criteria

• I have a table of several columns
Column A client code
Column B outstanding loan amount
column c type of loan numeric code

I have a list of client codes, and want to vlookup the code and sumif the loans referred to that client in a particular loan code.
thank you

## Files

• Re: sum if in combination to vlookup

You don't need VLOOKUP, Just use SUMIF.

=SUMIF(Table_Query_from_NEWAS4004[Client code],G3,Table_Query_from_NEWAS4004[Outstanding balance])

or

Use a Pivot Table

[COLOR="blue"][SIZE="4"][FONT="Verdana"]AAE[/FONT][/SIZE][/COLOR]
[COLOR="blue"]----------------------------------------------------[/COLOR]

• Re: sum if in combination to vlookup

Thank you,
but this gives the total outstanding amounts for the one client, i want to have the outstanding per loan,
for example client 4810 has two different loans, the said formula totaling up both, how to separate them? and have the answers in to separate cells. one for loan 53 and the other for loan 56.
thx again

• Re: sum if in combination to vlookup

USe a Pivot Table. See attached.

forum.ozgrid.com/index.php?attachment/45884/

## Files

[COLOR="blue"][SIZE="4"][FONT="Verdana"]AAE[/FONT][/SIZE][/COLOR]
[COLOR="blue"]----------------------------------------------------[/COLOR]

• Re: sum if in combination to vlookup

hi
thank you for your help, but i didnt know how to extract the information from the pivot table to the main sheet i work on,
the main sheet is in sheet 1 where i have a main table and need to add the loans outstanding amounts. i rely much on vlookup..
i want
vlookup the client number of sheet 1, in the loan sheet, to extract the loan code 53 outstanding, and in another cell in sheet 1 to extract the loan code 56 and so on..
(pls see attached sheet).
thank you

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!