Forum Discussion
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 ...
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)