Formula that sums hours where a single value matches a value in a multi select list AND month

DMcCallister

I am working on a formula that calculates hours worked where a member exist in a multi-value list and the month.

The detail is recorded in Run Data Sheet. Each record provided the date of the run, start and end time of the run, hours (difference between time in and time out), multi select list of the members that were on the run and then helper column to identify the month and year.

The second sheet is the time reporting for payroll. Columns: Members and then a column for each month. The goal is to pull the hours from the run report to create the payroll report for the month. I have the members listed in the first column but I am struggling to create the formula to sum the hours from the run record for the individual members.

Formula attempted =SUMIFS(RunSheetHours), HAS(RunSheetMember, MemberPayroll sheet), RunSheetMonth, "1").

Any help is appreciated.

Dawn

Brandon Austin

Hey DMcCallister.

You will have to 1st use a SUM Formula and then have to use a INT Formula to round it back up again. I was struggling with something similar,

This Sheet helped me.

https://app.smartsheet.com/b/publish?EQBCT=bde3993a5b7e408e9f112d2049f76662&_gl=1*hkvfss*_ga*MjEyMDM3OTMyOS4xNjYzNjY5MjM3*_ga_ZYH7XNXMZK*MTY2NDk3NzA5Ni41LjEuMTY2NDk3NzU0Mi41OS4wLjA.&_ga=2.166686014.1468266621.1664973412-2120379329.1663669237https://app.smartsheet.com/b/publish?EQBCT=bde3993a5b7e408e9f112d2049f76662&_gl=1*hkvfss*_ga*MjEyMDM3OTMyOS4xNjYzNjY5MjM3*_ga_ZYH7XNXMZK*MTY2NDk3NzA5Ni41LjEuMTY2NDk3NzU0Mi41OS4wLjA.&_ga=2.166686014.1468266621.1664973412-2120379329.1663669237

Kind Regards

Brandon