I am having an issue with a SUMPRODUCT Formula. In the attached excel, I am trying to take a weighted average of the square footage, versus the office. I know the formula would be (square footatage x the % of office)/total square footage. However, due to the format of my company's spreadsheet, I have to use multiple ranges in order to not include the totals for each building.

All help is appreciated. My guess at the formula is in cell E565 (highlighted yellow in red font)

Thanks.Sumproduct Issue.xlsx