Hi Everyone,
I have a very long spreadsheet and need to sum the total hours worked by each employee based on which worksite they worked.
I have the data sorted in columns by employee, then by worksite, then by hours. My question is how can I get the "sum" of hours by worksite? Here is an example below:
Mike Smith Fort collins 4
Mike Smith Fort collins 5
Mike Smith Fort collins 5
Mike Smith SeaWorld 3
Mike Smith SeaWorld 5
How can I get it to give me 14 hours for Fort collins and 8 hours for SeaWorld????
This is a basic example but the real spreadsheet is 1000's of rows so I hate manually summing each week so THANKS!!!
I have a very long spreadsheet and need to sum the total hours worked by each employee based on which worksite they worked.
I have the data sorted in columns by employee, then by worksite, then by hours. My question is how can I get the "sum" of hours by worksite? Here is an example below:
Mike Smith Fort collins 4
Mike Smith Fort collins 5
Mike Smith Fort collins 5
Mike Smith SeaWorld 3
Mike Smith SeaWorld 5
How can I get it to give me 14 hours for Fort collins and 8 hours for SeaWorld????
This is a basic example but the real spreadsheet is 1000's of rows so I hate manually summing each week so THANKS!!!