Ugh! Because your data is split up by month, the formula will need to sum up each spreadsheet. Also, if the vacation time is accrued based on start date and not calendar date, then there will be carryover from workbook (2015) to workbook (2016). Right? Can we modify your spreadsheet setup?