Sep 18 2019 06:49 AM
Sep 18 2019 08:26 AM
In general yes, it looks like it could be SUMIFS or even better Pivot Table. To be more concrete better if you submit small sample file removing from it all sensitive information.
Sep 18 2019 11:56 AM
Here is the spreadsheet. Although there are columns for first name and last name, they do not appear on the survey- which is unfortunate., since people do not always enter their name exactly the same. I left the time-date stamp columns in in case they provide any useful info.
Sep 18 2019 03:34 PM
I see, at that's the main issue no exact identification for the people. Excel has no idea that differently spelled names are belong the same person.
In attache file some quick mockup of how it could be.
First, it's better to collect source data in Excel table, it'll be easier to summarize and filter/sort data.
One solution could be to aggregate the hours using Pivot Table.
Another way to transform a bit using Power Query and return aggregated data from it. Here we may could some preliminary transformation like remove extra spaces, capitalize names and like, thus we will have more matches.
But in any case we will have not matched names for same persons. Here is only to check the result, based on it correct source data manually and refresh the summary after that.
Another way use kind if ID:s for people they have to fill. That could be just sequential 3 or 4 digits numbers.
Sep 19 2019 02:44 PM
I appreciate your information. I do not know why the survey was chosen as the means to enter data, but I believe the administration of the organization is intent on keeping it. Pivot Table and Power Query are beyond my working knowledge of Excel. Thank you for your time!