How to condense data to single rows on a different sheet

I have a "Raw Data" sheet with columns and columns of data. It has many blank cells throughout the sheet. I want to condense the multiple rows based on specific variables. In similar past efforts, I used a similar formula (below) with great success:

=IF($A11="","",SUMIF('Raw Data'!$FA$2:$FA$200,$A11,'Raw Data'!T$2:T$200))

It doesn't work this time and I'm not sure why, maybe because my data this time includes text??? I have attached a sample workbook for review. The "Raw Data" sheet contains data in actual column location. Sheet 1 is my desired output and the formula I referenced. Thank you!