I have two tables, one with a list of payroll dates(vertically) for a company and another that is a payroll download that includes payroll dates(vertically), gross pay and employee information. In excel I used the sumif formula to say in sheet 2 sum ...