Thank you for your help. The formula above is essentially the same as the formula I was using, but my formula continually threw an error stating that the formula required too many resources to process so it would not calculate.

To update for anybody else that encounters this thread, I was using named ranges for the various ranges and finally, upon seeing the formula above, realized that the named ranges were entire columns instead of just the cells containing results. The actual dataset was 45 columns wide, so the entire range that the SUMPRODUCT function was trying to reference was 45 columns X 1048576 rows.

By using a dynamic named range =OFFSET('Sample Data Sheet'!$C$3,0,0,COUNTA('Sample Data Sheet'!$C:$C),12) to only select the rows containing data (about 1200 on the actual file), the formulas calculated perfectly.

Thank you again.