This issue is more than a year old now.

I got motivated a couple of months ago and noted the error still exists in QB 2020, so I checked it out to see what was going on.

I found several issues with the workbook and fix them. The fixes were easy and took a couple of hours to find, fix, and test.

Then I published an updated version for people that need it.  Start here to get it: Summarize Payroll Data In Excel « Big Red Consulting