I have 5 worksheet tabs in my workbook. Their respective names are:

1. Total

2. 101

3. 209

4. 408

5. 708

The formula that I currently have that is giving me a #VALUE! is

SUMPRODUCT(SUMIFS(INDIRECT("'"&SheetList&"'!B$18:B$23"),INDIRECT("'"&SheetList&"'!$A$18:$A$23"),$A4,INDIRECT("'"&SheetList&"'!$B$17:$N$17"),B$3))

My problem is the last part of this formula. My range is B17:N17 which are all dates . The worksheet tabs 101, 209, 408, and 708 are not identically set up regarding range B17:N17. For example in tab 101 Cell B17 has a date of Mar-13 while in tab 209 Cell B17 has a date of Sep-13.

I am sure there is a way to solve this,

This is how my Total Tab looks:

Oct-13 | Nov-13 | Dec-13 | Jan-14 | Feb-14 | Mar-14 | Apr-14 | May-14 | Jun-14 | Jul-14 | Aug-14 | Sep-14 | |

Rent | #VALUE! | |||||||||||

Principal and Interest | ||||||||||||

Property Taxes | ||||||||||||

Maintenance | ||||||||||||

Special Assessment | ||||||||||||

Profit/Loss |

<colgroup><col><col><col span="11"></colgroup><tbody>

</tbody>

Thank you