Forum Discussion
xl-user
Sep 27, 2019Copper Contributor
lease payment calculator
I want to set up an excel file that calculates the payment per month on a Fair Market Value lease. Can somebody please direct me to a function in excel. Thanks !
vigneshasokan7
Sep 28, 2019Copper Contributor
Hi!
You Can Solve this using SUM IF formula.
=SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], ...)