Forum Discussion

0720's avatar
0720
Copper Contributor
Jun 03, 2025

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

  • Patrick2788's avatar
    Patrick2788
    Silver 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)

     

    • 0720's avatar
      0720
      Copper 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 

Resources