Hi,
I have a loan list on one sheet, and I need to get the total of the outstanding balance from another sheet which contains all loans from inception.
Currently, I am doing a vlookup, to bring back the balance ont he first sheet, then doing a total at the end of the list, and then copy, paste special value into a third sheet.
Is there a formula that I can insert in the third sheet to get the same result?
Thanks,
Aurora
I have a loan list on one sheet, and I need to get the total of the outstanding balance from another sheet which contains all loans from inception.
Currently, I am doing a vlookup, to bring back the balance ont he first sheet, then doing a total at the end of the list, and then copy, paste special value into a third sheet.
Is there a formula that I can insert in the third sheet to get the same result?
Thanks,
Aurora