I have 2 columns:

Column A: list various prices

Column B: list various job numbers that associate to the price on column A

Goal: to come up with a total for each job and also label the job number itself.

For example:

Column A Column B

59.52 1093

58.28 1089

32.00 1093

25.28 1089

Result: (formula)

1093: sum

1089: sum

I know the sumif formula but I still have to specify the job number for every formula and need to label the job manually. So, I am wondering if there is a way to write a formula for such request?

Thanks so much.