A4:A6 = {0,1} - your switches

In subtotal row write:
=SUM($A$4:$A$6*C$4:C$6)
followed by CTRL+SHIFT+ENTER
and copy to other columns.
--
HTH, Tomek Polak, http://vba.blog.onet.pl