Summing cells which are flagged in some way

[Guest]

Hi
I have a series of budget figures in a row. Some of thes are committed and
some are not. I want to sum only those which are committed. Can I do this by
text colour or some other flag. I have read some other posts with VB code for
colour text functions but dont know how to implement them. Is there an easier
way?
Thanks for looking
Keith

 

[Carim]

Hi Keith,

Take a look at the SUMIF(range,criteria,sum_range) function

HTH
Cheers
Carim

 

[Guest]

Thanks Carim I tied that but SUMIF will not recognise a format condition as
far as I can see.

 

[Carim]

Keith,

I am sorry ... I read your post too quickly ...
To handle colors, take a look at Chip's solution

http://www.cpearson.com/excel/colors.htm

HTH
Cheers
Carim

 

[Guest]

Hi carim

Thanks for that. I've tried it and have got soemthing working now. Just
seem to have to hit ctrl+alt+F9 to force the recalculations. Thanks again
Keith