Hello everyone,
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:
<colgroup><col><col><col span="11"></colgroup><tbody>
</tbody>
Thank you
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