Sum Formula Help

I made a change to the Employees sheet from John Doe to Emp 1, Emp 2, Emp 3. I also greatly reduced the sheets so that the file would upload, however I feel that there is enough left that you will be able to see what is going on.
Since column A at the bottom of the sheet isn't being used, I put the jobs (pipe, wrap etc) in that column (you can hide the added text by changing the font to white as demonstrated beginning with wrap).
After making those changes the following formula populated the bottom of the worksheet:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Assuming that these values will go at the bottom of the sheet in column G, the following formula populates G47 and down:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

MMULT is one alternative to SUMPRODUCT. Try this and let me know if it helps. In G48 and filled down.

Formula:

Please Login or Register  to view this content.

It seems to me that what is slowing the spreadsheet down is that each time you enter a number in a cell at the top of the spreadsheet, it recalculates all of the formulas at the bottom. If there are 750 employees multiplied by four jobs multiplied by the number of stats being tracked (feet, hours, weeks etc.) then that takes time. Seems that what would be preferable would be to have the spreadsheet wait until you have put in the values in the cells at the top before it starts calculations in the formulas at the bottom. That being the case you might consider point number 9 in this article, which is about setting the calculation mode to manual.

According to this article you are correct. Admittedly I don't work with the backstage options often, which is why I waited so long to post my suggestion, and why I referenced an article.
I hope that the change sped up/improved the worksheets performance?

I trust you've read the article cited by JeteMc in Post#9.

To go a step further.

Are there any values in $C$6:$CX$1805 that reference directly or indirectly:

• Cells that have any volatile functions?
• Dynamic Named Ranges that contain volatile functions?
• Named formulas that contain volatile functions?

The point being that volatility is also inherited.
That is a point not often raised on the topic.

You must have a really fast computer, mine took several minutes to calculate after having pressed F9 (this was on the zipped workbook). I am glad to hear that the spreadsheet is now working as desired. Reading the second article more closely ver 2013 offers several options for manual calculation in the last paragraph. At any rate if the solutions provided are satisfactory please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.