使用sumifs或其他公式计算列标准的Excel

I am trying to write a excel formula that will calculate a data set based off of the column header for an area. Essentially, I am using it to help automate some of the mundane reconciliations that I do.I am trying to write a excel formula that will