Insert the numbers of a table in the last row of a different table (no VB)

Hi MRAfshar3000 

thanks for the screenshots, this is much better. So, it looks like what we call T-accounts, where you put something on the debit side and something on the credit side.

There is probably an easy solution if you use Microsoft 365 / Office 365 (and Excel 2021), because there you have the new dynamic array functions like FILTER.

I tried to rebuild a small example, I have also attached the example file:

So in the above example, the formula in A14 would be:

=IFERROR(FILTER(A2:A8;C2:C8=A12);0)

The surrounding IFERROR just avoids that you get #KALK-errors if an account name is not found.

Just note, that depending on your regional local settings you might need to replace ; with ,

So 

=IFERROR(FILTER(A2:A8,C2:C8=A12),0)

The bad news is, that this FILTER-function is not available in older Excel versions before Excel 2021. In this case, I do not have a solution for you, unfortunately.