I would like to have a button on the sheet assigned to sum a cell colour so someone can go through and colour the cells (lets say within rows B&C) and then hit the button to provide the total sum.

different button for each colour.

does that help?