Conditionally calculate formula in spreadsheet.

B

Barbara

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?
 
B

Barbara

Thanks Gord,

Is there perhaps an easier way - maybe tagging the cells or something?

Thanks

Barbara
 
P

paul

how are the cells coulured in the first place???Are they manually
fomrmatted?If you have some kind of conditional format use those condotions
to do a sumif()
 
G

Gord Dibben

Barbara

If the cells are formatted via Conditional Formatting use the same criteria
for summing.

If manually formatted, any tagging would have to be done through some sort of
value using a COUNTIF formaula or somesuch, not by the formatting.

If there is an easier way, I hope to learn it.


Gord
 
Top