I am trying to figure out a way to use a formula for this scenario:
In "December 2016" and "January 2017" tabs, there is a row in each tab (ie row 2) that I want to sum. In Row 1 of each of those tabs are dates. I need it summed based on a date range that is broken down on a separate tab. On this "reference" tab, column A would have the beginning date, column B end date and this would continue for multiple rows for the calendar year. I could use column C (and onwards) to show which tabs to look into as well if it helps.
I'm sorry if I didn't explain this very well...hopefully someone can help? Please and thanks!