Any alternatives to SUMIFS and COUNTIFS to speed up a workbook's calc time?

I've got a large workbook with about 10,000 rows and 58 columns. Most of the cells have static data, however a number of columns use formulas/functions which include SUMIFS, COUNTIFS, INDEX, and MATCH.

(The purpose of the workbook is to evaluate a variety of trader's track records and determine which ones might contribute toward an optimal portfolio. By changing column B from 0 to 1 allows me to turn on or off a particular trader's history).

The problem is that making any change in the workbook, requires about 12-14 seconds to compute.

I've attached a small section of the workbook, highlighting some of the columns which include the formulas I believe are slowing down the workbook.

One which I suspect might be the culprit is this:

Please Login or Register  to view this content.

The reason the array goes down 40,000 rows is so that I don't have to change the formula every time I add another 5,000 rows or so of data. Would it just complicate things if I counted the rows and used the ADDRESS function to tell the formula how many rows to search down?

My computer is reasonably fast: 16Gig RAM and an AMD Ryzan 3 2200U CPU. (it doesn't have a SSD though. Could that slow down the workbook?).

Thanks!