I have no idea why Intuit cannot implement the fix this person has provided for years: This works like a charm:
https://bigredconsulting.com/products/summarize-payroll-data-in-excel-fixed/
