How to calculate total hours of work per month for each resource
Hi all, l am trying to sum the total number of hours each person within our team has worked across different contracts. However l am not sure the correct formula to use for this? I believe if would be a SUMIF but every formula l attempt either brings it back as invalid or unparseable. I have attached a screenshot the smartsheet I am working on. Resource 1 is the column that l would get the name of the resource from, and the date columns ie 01/03/2021 are where their hours are inputted into for that month.