sum month to date data based on match or vlookup

[Jbooze]

This seems like it should be pretty simple. I have a spreadsheet that will have 31 tabs, one for each day of the month. I want to use one formula for each tab that will search for a match of the tab name (example '25th' tab name) in a column that has all 31 listed and when found, sum the 1st through the 25th for a month-to-date total and likewise for the rest of the days (tabs) of the month. This way each day tab will only be showing totals up to the date completed so far. So if the 25th is on the 25th line in column A and matches the tab name in this tab (25th), sum cells 1 through 25 in column B. The formula would then be able to work for all tabs. Does anyone know how to do this or something similar?

Thanks,

Jeff

 

[Biz]

I think you may need

=SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!A2:A1000"),A2,INDIRECT("'"&SheetList&"'!B2:B1000")))

where SheetList refers to a range that lists the relevant sheet names, A2:B10 the relevant range in every sheet in SheetList, and A2 the criterion value.

SheetList would have names of daily sheet ie 1, 2, 31.

Hope this helps.

Biz

 

[Jbooze]

I appreciate the assistance. I was unable to get this to work. Each tab will have a list of the tabs, 1st through the 31st in column A. The formula is only working with in one tab to find the data. I just want to be able to use the same formula in all tabs since there are multiple places it needs to be used used. The formula would check which tab that it is working out of example the 25th and when it determines that the tab the formula is in is the 25th, then it would find the 25th in column A25 and sum b1 through 25. Column A has the list of tab names or dates (1st through 31st) named the same as the tabs. Since the tab is the 25th, it finds the 25th in column A which is in cell 25 and sums b1 through 25 for the total number of calls offered month to date on the 25th. Any assistance or variation of this that can be provided would be greatly appreciated.

Thanks,

Jeff