Hi Folks,
I have an issue that is perplexing me.
I currently have the below formula:
=SUMPRODUCT(SUMIFS('Data - CURRENT'!$K:$K, 'Data - CURRENT'!$R:$R, Receipted_status, 'Data - CURRENT'!$B:$B, "Area 1"))
This just pulls in all data regardless of the period.
However, the data that I have is spanning a whole year. The data that I am reporting on is within a rolling 12 month period. I have two requests if I may be so bold:
1. I need to just report on the previous month and bring back a certain total figure - hence the above formula.
2. I need to report a breakdown of the previous 12 rolling months. This month report will be March 2013 to February 2014. Next month it will be April 2013 to March 2014 and so on.
For the first one, to bring back the previous month I would use: =TEXT(DATE(2014,IF(MONTH(TODAY())-1>0,MONTH(TODAY())-1,12),1),"MMMM") but not sure if I am barking up the wrong tree and how to add this to my original formula??
As I said...perplexing!
Thanks for your help.
Bookmarks