I drastically cut down the OP's workbook to make a sample to show how the formulas (SUMPRODUCT based) work (post #4). The OP says that while the formulas work, the actual spreadsheet freezes when scrolling or selecting a cell and then reports that it is calculating. The original sheet has 200 columns and just over 2400 rows of data, which along with 2 other sheets weighed in at @ 1.4M (OP attached a zip file to post #1). My instinct is to suggest changing the Calculation Options to Manual, however I have never done this with one of my spreadsheets, and am not sure that this is a good recommendation. I would appreciate someone with experience along the lines working with large amounts of data would give the OP some advice. Thanks.
http://www.excelforum.com/excel-form...ml#post4598990