Summing columns

Hi I'm trying to find one formula that can sum up the data responding to another criteria and then insert a row to total that sum. See attached example explains this better.

Is it possible?

Thanks