Formula to filter then create Subtotals

Hi,   I am trying to create a report ( similar to a subtotal function summary) but without using the subtotal method. Data is on the source data sheet. I need a formula or idea to filter the data ...