count something based on two criteria

Hello,

I was seeing if I can get some help on the following scenario of data:

I have table 1 with the following data:

I need to take this data and be able to create the following table2 from it using calculated columns: basically need to know how many times each audit shows up for each truck number. Thanks!