Hello! Hope someone can help. I have a lengthy list of Job Codes and the hours billed to them. I would love to have a formula that looks at the data, compares one row to the row above and below it, determines if it's the same (and do nothing) and if it's not the same, sum all the values for the group with the same job codes.

I apologize if i didn't describe this well; I've had this done to a spreadsheet of data before but cannot remember how.

Here's another way to describe it: Similar to Sumif function only it's SUMIF the job codes are not the same (and sum all the codes that are the same).

Hope to get some help! Thank you!

On the same note, is there a way to basically have the functionality of a pivot table without using the pivot table? I.e. I need to summarize the data like a pivot table does only instead of drilling down into the data, have it listed in columns.