Autofill IF sentence through large table with input from both rows and columns

My first thoughts:
Check if you cannot make your life easier by using proper addressing (mixed $A1 A$1 or absolute $A$1 also, not only relative one A1 as you have now).
Instead of several IFs and chceking in one column for some condition, and summing another column when the condition is fulfilled use SUMIF function.
Look at INDIRECT function and may be also ADDRESS function. OFFSET could also be usefull.

And standard suggestion:
Attach a sample workbook (not/not_only a screenshot). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic