Multiple Category Summary Multiplication

Hi all,

I've been struggling to find a solution to the following problem - I think an image might best help explain:

Screenshot 2019-09-09 at 11.23.45.png

I'm looking to create a summary table (the orange one) dependent on how many times a category appears in the blue table. So for example, A appears 3 times in job 1 at a value of £1. It also appears twice in job 2, but at a value of £2.50, etc etc. How can I create the table on the right to correctly have a total value based on how many times it appears in the main data table, and multiply by its respective line value? I hope this makes sense.

Oh not quite sure why that didn't work!

Here's the image:

Screenshot 2019-09-09 at 11.56.10.png

Hopefully that works now. Just to reiterate the following problem:
So there's a total value in the orange table as before, but there's another column that will have values ONLY if there a date in the column.

Thank you so much Paul, worked a treat!