Formula to populate a table based on two criterion

[KIBAAKO]

Hi.
I have a sheet with names of persons and amounts borrowed and dates in a sheet named LOAN LEDGER. Each person is allocated a whole page. I was to populate this information on a different sheet, based on two criterion, NAME of the person and DATE which the amount was given, probably by matching. Can anyone please help. Attached is a worksheet with sample results. Thanks

[63falcondude]

After removing the trailing space after TOM in cell B3 (i.e. change "TOM " to "TOM"), and correcting the spelling in B4, try this in C3:

=IFERROR(1/(1/SUMIFS(LOAN_LEDGER!$E:$E,LOAN_LEDGER!$A:$A,$B3,LOAN_LEDGER!$C:$C,C$2)),"")

Drag to the right and down.

[KIBAAKO]

Thanks. It worked perfectly

[KIBAAKO]

Hi.
I had requested for help with a formula, for which I was assisted with it i.e.
=IFERROR(1/(1/SUMIFS(LOAN_LEDGER!$E:$E,LOAN_LEDGER!$A:$A,$B3,LOAN_LEDGER!$C:$C,C$2)),"")
The formula worked but there is still one more hurdle, this more condition that, IF PURPOSE (cell B in LOAN_LEDGER worksheet ) is empty, then the corresponding cell in the populated worksheet should also remain empty. Attached is a worksheet with sample results. Thanks

[KIBAAKO]

Hi.
Please am humbly requesting someone to assist me in the above post.
Thanks

[Pete_UK]

You can just add that condition to the SUMIFS, i.e.:

=IFERROR(1/(1/SUMIFS(LOAN_LEDGER!$E:$E,LOAN_LEDGER!$A:$A,$B3,LOAN_LEDGER!$C:$C,C$2,LOAN_LEDGER!$B:$B,"<>")),"")

Hope this helps.

Pete

EDIT: Ah! Beaten to it

[63falcondude]

Including this into the original formula should do what you are looking for.

=IFERROR(1/(1/SUMIFS(LOAN_LEDGER!$E:$E,LOAN_LEDGER!$A:$A,$B3,LOAN_LEDGER!$B:$B,"<>",LOAN_LEDGER!$C:$C,C$2)),"")