sum if box is checked
 

Hi,

I have this formula in cell E37:
IF(E30=TRUE,+C30,IF(E31=TRUE,+C31,IF(E32=TRUE,+C32 ,IF(E33=TRUE,+C33,IF(E34=TRUE,+C34,IF(E35=TRUE,+C3 5,IF(E36=TRUE,C36)))))))

I have one "forms" checkboxe each in cells C30:C36. I have each checkbox
tied to the cell it's in. In the C column I have prices. C30 is $399. C31 is
$399. C32 is $279. C33 is $279. C34 is $450. ect.

I want to cells E30:E36 to reflect the prices in column C if the check box
in Column E is checked.
My formula works, but only for 1 of the cells. If the other cells are
checked, it won't add them to the total in E37.
Where do I need to put SUM function at in the formula to get a total in E37
but only if the checkboxes in E30:E36 are checked?

Thanks for looking at this for me.

Rob