Forum Discussion
0720
Jun 03, 2025Copper Contributor
excel changing input values
need help anybody i have worksheet for jobs with varying job numbers but need to sum up the man hours spent on a job like the one shown below. the job numbers in all rows are changing during input and i need to tally all the hours spent in a specific job/s. i called it job manhour, accumulated manhr spent on a job. can somebody give me idea on how to do it best pls....
10 Replies
Sort By
- Patrick2788Silver Contributor
The recommended approach is to consolidate the days data into 1 table like this:
Then the solution becomes very simple:
=GROUPBY(JobTbl[Job Numbers], JobTbl[manhour spent], SUM)
- 0720Copper Contributor
many thanks patrick, i am working on it now trying to use your recommended option. i will be keeping in touch here for some other things i may need. again many thanks
- Patrick2788Silver Contributor
Glad to help. You're welcome!