sumif for date ranges from multiple tabs

[RickMcc]

Hi all,

Me again. Today's quandary is a date range query for calculations (sums & average) when there is a tab for each day of the month. I'm pretty sure this is done using the =sum(sumif(indirect( formula. I'm just trying to figure out how to set it up. What my end user wants to be able to do is enter a day of the month, and be able to calculate all fields from the beginning of the month to the date entered. Attached is a sanitized version of the workbook to look over. Thank you for any help or suggestions.

Rick