There is a table of which you can select the month and the department and I need it to do the following:
If J9=Appletree then go to sheet1! and find appletree in M4:M4575 and sum up these dates.
Once the formula finds appletree (which will be numerous counts of this cell) it needs to then sum up a rolling 12 month history of data which sits in E4:E4575.
Basically when you select the current month in D5, D6 will compute the month that is 12 months behind. The formula will read sumproduct or sumif(e4:e4575) if greater than D6 and less than D5.
Am I trying to do too much in one formula or can this be done?
If J9=Appletree then go to sheet1! and find appletree in M4:M4575 and sum up these dates.
Once the formula finds appletree (which will be numerous counts of this cell) it needs to then sum up a rolling 12 month history of data which sits in E4:E4575.
Basically when you select the current month in D5, D6 will compute the month that is 12 months behind. The formula will read sumproduct or sumif(e4:e4575) if greater than D6 and less than D5.
Am I trying to do too much in one formula or can this be done?