Automatically Sum rows that have the same value in a specific column.

Jeff Bortner

I would like to sum up the hours of a job according to what job number it has. This is going to be used as a Time Sheet. Therefore, mass amounts of entries are going to be sent to this report. I would like it to automatically sort the information and then sum up the hours of multiple cells that have the same job number in their row.

 

I already know how to sort the information. I just dont know if there is a way to combine information automatically like that?

Jeff Bortner

Figured it out, by using the SUMIF() function. Not sure how to delete post.