use formulas to transpose and sum values based on multiple criteria

Hello,

I am in essence trying to transpose data using formulas to sum values, except that I need to match against 2 criteria. i.e. Dates are displayed in 1 column, Departments are displayed in 1 row multiple columns and sometimes duplicated, and values are in each row below the Department row. I want to transpose the data so I have 1 column for the Dates, 1 column for the Departments, and a 3rd column to sum the values. I attached an example of what I'm trying to accomplish. Any ideas for what formula to use to sum the values that match the 2 criteria for Date and Department?

Thanks!
Rebecca

In C2, put

=SUMPRODUCT(('Source Data'!$A$2:$A$26=A2)*('Source Data'!$B$1:$K$1=B2)*'Source Data'!$B$2:$K$26)

Perfect! Thank you!!

You're welcome.