Excel Summary

Hi,

In Tab1, I want to derive result of Total Cost against each department from "Payroll Summary" tab. For example, Sales department must show total cost of 94,226.16 as a single cell and not with filter option.

For Tab2, I want to have summary of products and shipping amounts(transaction type) from "Sales" tab for each state(billing region). The amount should be Amount (after discounts and taxes) from X row. Both Product and Shipping (C and D column) summary should have same formula. 

I have attached file herewith. Please let me know in case of clarification.

I would be oblige for help.