Sumproduct to add total qty from several columns

I've been trying to use sumproduct to get a sum of the total items in house or total items at outside vend.
I need something that will be able to differentiate from parts in house to parts outside vend and put the total sums into M2 and M4

thanks in advance for the help.

Please see the attached sample