Summing cells which are flagged in some way
 

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

Summing cells which are flagged in some way
 

Hi Keith,

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

HTH
Cheers
Carim

Summing cells which are flagged in some way
 

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

"Carim" wrote:

Hi Keith,

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

HTH
Cheers
Carim

Summing cells which are flagged in some way
 

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

Summing cells which are flagged in some way
 

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

"Carim" wrote:

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