Calculate the total Rental Income for values greater than $70,000. Make sure to use a SUMIF...

Transcribed Image Text:

Calculate the total Rental Income for values greater than $70,000. Make sure to use a SUMIF function. Discount Rate 3.50% Time (Yrs) Rental Income 0 $ 55,000 1 $ 68,000 2 $ 77,000 3 $ 85,000 4 $ 91,500 5 $ 98,700 6 $ 101,500 Calculate the total Rental Income for values greater than $70,000. Make sure to use a SUMIF function. Discount Rate 3.50% Time (Yrs) Rental Income 0 $ 55,000 1 $ 68,000 2 $ 77,000 3 $ 85,000 4 $ 91,500 5 $ 98,700 6 $ 101,500