In a workbook there are worksheets named North, South, East, West, and Stats. All four worksheets are formatted the same and have the same columns. Column A contains the date of inquiry. Column Y contains the number of days for processing the inquiry. On the Stats worksheet one of the stats is a monthly breakdown of other data. In column B of the Stats worksheet the numeric date for the first of each month is entered in a cell which has a custom format of MMM. The Stats worksheet contains data broken out by year for a two year period. The formula needed is to have a year average of all four worksheets for the number of days to process the inquiries with in a specific year. The formula will appear on the Stats worksheet. The formula can reference one of the cells in column B on the Stats worksheet to identify what year the stats are to be collected for.
The desired formula will reference a cell in column B of the Stats worksheet to identify which year to search for. Then search column A of the four worksheets and identify the dates that fall with in the identified year and sum the number of days to process the inquiry which is contained in Column Y. I have been unable to write the formula properly.
Your assistance is greatly appreciated.
1/5/18 - Prior to posting this request I had previously searched the internet for a similar formula that I could adapt but I did not find one.
Bookmarks