Date range formula help

Sean Murphy

@Paul Newcome looking for your expertise again!

I'm looking to automate/expatiate our time keeping process to pay subs. I've had no luck after a few hours, so figured I'd reach out. See the screen shots below. The goal is to have a each employee and their total weeks pay consolidated on a line based on a specific date range. I'm totally open to adding/removing any columns. I'm thinking it's going to be along the lines of this, but I'm striking out =SUMIFS({HDZ Red plant labor Range 1}, {HDZ Red plant labor Range 3}, @cell = [Employee Name]1, @cell >= [Pay period]1, @cell <= [Pay Period End]1)

Paul Newcome

Try working on something along the lines of...

=SUMIFS({Other Sheet Column to Sum}, {Other Sheet Employee Column}, [Employee Name]@row, {Other Sheet Date Column}, AND(@cell >= [Pay Period]@row, @cell <= [Pay Period End]@row))

Paul Newcome

Yes and no. You can set up a sheet that contains their names and rates, but you would still need to at least manually enter their names on the tracking sheet so that formulas would have something to compare against.

Paul Newcome

Try working on something along the lines of...

=SUMIFS({Other Sheet Column to Sum}, {Other Sheet Employee Column}, [Employee Name]@row, {Other Sheet Date Column}, AND(@cell >= [Pay Period]@row, @cell <= [Pay Period End]@row))

Sean Murphy

Perfect!! Thanks!!

Paul Newcome

Happy to help! 👍️

Sean Murphy

@Paul Newcome Hey Paul, want to pick your brain again on this sheet. I'm running into our subcontractor bringing in new employees fairly regularly (rotating them based on needs really). Is there a way, if I have something along a "master employee list", that I can add the new names & their rates, and have my main time sheet (above) auto-populated? I'm currently going in and manually adding (copy and paste to each day) a line to each day with the new employee.

Paul Newcome

Yes and no. You can set up a sheet that contains their names and rates, but you would still need to at least manually enter their names on the tracking sheet so that formulas would have something to compare against.

Sean Murphy

That's what I assumed, thanks!

Paul Newcome

Happy to help! 👍️