Monday, December 5, 2016

yogi_From Table of dates And Amounts Compute Lastt Month's Income Average income And Current Month's Income

Google Spreadsheet   Post  #2092
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-05-2016

Calculating Last Month's Income

 I'm trying to dynamically calculate the income for last month. There will continue to be a dynamic data set with new values each month, typically with multiple entries per month so the rows of data will continue to expand. I'm looking for the formula to always sum the total income for the month prior to this current month. 

Additionally, I'm also looking to calculate the historical average monthly income.

I've prepared a mock sheet to illustrate what i'm looking for here: https://docs.google.com/spreadsheets/d/1lx8OT64Dzw0JsoWzOXIDVvX21PePTh0hvhxCXdyUMSc/edit#gid=0

thanks in advance

(side note for anyone looking at this past the month of jan 17, feel free to add new data for the formula to update)