Code to Filter, Sum and return a value from data set

I've been working at my current job for a year and have pretty much tapped out the Excel resources. I'm at the point where I need to learn VBA, so any suggestions/tutoring would be appreciated.

I deal with large amounts of data. For a score card I need find a way to filter data based on two constraints, sum it and display the output in a table. The two constraints are: Business Unit and Maintenance Type

I played around with recording filters, but the code becomes very unwieldy. From past experience with this site, where I used 10 lines, there's a way to do it in 2.

Please take a look at the attached example book, a truncated data set and the output.


Thanks,

Example Book.xls

The code works. I just added the equivalent workbook functions.