We have a sales spreadsheet that shows confirmed and projected sales. The
projected income from various items is shown in red in our spreadsheet, while
confirmed sales are in black.

My question is, can we create a formula at the bottom that automatically
totals only the red coloured figures, leaving out the black, without having
to click on each individual cell?