How to keep the Last Crieteria from changes in a Formula

I had an earlier post but I didn't have the sheet fully designed and I requested help with the first formula I was using Countif. I got some good suggestion, but I have fully finished the spreadsheet. I was able to fix that except for some Negative count but that not my concern. There not that many and I can manually fix that. However, I have a formula that I have listed in Column C,D,E. The formula is working and is :

Column C=SUMIFS('Data Subtotal'!E:E,'Data Subtotal'!C:C,A3,'Data Subtotal'!A:A,C1)

The problem is that I need C1 at the very end to stay the same when I copy it down the column.

Column D=SUMIFS('Data Subtotal'!E:E,'Data Subtotal'!C:C,A3,'Data Subtotal'!A:A,D1)

The problem is that I need d1 at the very end to stay the same when I copy it down the column.

Column E=SUMIFS('Data Subtotal'!E:E,'Data Subtotal'!C:C,A3,'Data Subtotal'!A:A,E1)

The problem is that I need E1 at the very end to stay the same when I copy it down the column.

The part that says "'Data Subtotal'!C:C,A3" should change to 'Data Subtotal'!C:C,A4, which it does.

I have attached a spreadsheet as an example

Thanks in Advance for your help. If this is even possible.