Thanks for the help in advance - Below is a sumproduct formula that works:
=SUMPRODUCT(--($D$6:$Q$6='Pro-Forma'!$H$5)*('RENT ROLL'!$U12="Insurance"),INDIRECT('Operating Expenses'!$C$7))
This one doesn't:
=SUMPRODUCT(--($D$6:$Q$6=$H$5)*('RENT ROLL'!$U12="Ins"),INDIRECT('Operating Expenses'!$C$7)+('RENT ROLL'!$V12="Util"),INDIRECT('Operating Expenses'!$C$8))
Range D6:Q6 is a series of year end dates (12/31/2015- 2028), and H6 is the date that I am looking for. The cell following the indirect is a named range for a specific line item.
I need to be able to add or remove line items...There are 8 named range line items altogether.
Bookmarks