For something like this you should use IF instead of SUMIF, but, I don't think you can use a formula with the checkboxes, you'd have to use VBA.