Sum Of Last Three Entries In Rotating Columns
Hi, I entered the years in row 4, 2006, 2007 etc€¦ starting in E4 and working
right. I then entered Jan thru to Dec in Column D, starting at D5. At the end
of each month I enter a value within the spreadsheet Corresponding to the
Month and Year. How do I get the sum of the last three months when the value
data is entered down one column and then starts back up and down the next
column to the right?
|