Forum Discussion
BRaff
Apr 03, 2019Copper Contributor
Return value only in rows specified by entering a number in an exterior cell to the table
I have an amortization table and I want to be able to calculate extra payments on the loan by entering the extra payment amount in a cell as well as the payment numbers and have the table return thos...
Twifoo
Apr 04, 2019Silver Contributor
You may enter this formula in F12, copied down the rows:
=SUMPRODUCT(({3,5,6,7,10,15}=B12)*1000)