I don't know enough about the 365 version of Excel to suggest why you should get a #SPILL error, however...
The formulas shown in columns Q:R on the Database sheet of the file in post #3 are array entered formula which may be slowing the workbook.
Try the following regular formula in Q2 copied over and down to R10:
Formula:
=INDEX('Report Filter'!D$2:D$455,AGGREGATE(15,6,(ROW('Report Filter'!D$2:D$455)-ROW('Report Filter'!D$1))/('Report Filter'!$B$2:$B$455=$M2)/('Report Filter'!$C$2:$C$455=$N2)/('Report Filter'!$A$2:$A$455=$F2),1))
Let us know if you have any questions.
Bookmarks