Summing cells which are flagged in some way

K

Keith Bliss

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
 
C

Carim

Hi Keith,

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

HTH
Cheers
Carim
 
K

Keith Bliss

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

Keith Bliss

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
 
Top