Hi

I have a column where formula produce values where the text is conditionally
coloured according to its value, ie negative numbers are red, positive are
blue and black. How can I sum column values that have black text.

Thanks
Alec

Hi,
You could probably use SUMIF, and just use the same condition you used to
make the font black in the Cond Formatting.
Regards - Dave.

Thanks for your reply Dave.

What do I put in the "Criteria" section?
I need the criteria to select black coloured text values, and ignore other
coloured text values.
Criteria does not allow me to use CONDITION FORMATTING as I used before.


"Dave" wrote:

Hi,
You could probably use SUMIF, and just use the same condition you used to
make the font black in the Cond Formatting.
Regards - Dave.

But what is the criteria being used in your conditional formatting in
order to make the cell black? If it was, for example, for values
greater than 25, then your formula would be:

=SUMIF(condition_range,"25",sum_range)

I don't know what columns you are using - substitute the appropriate
ranges for condition_range and for sum_range.

Hope this helps.

Pete

On Apr 5, 7:04*pm, Alectrical
wrote:
Thanks for your reply Dave.

What do I put in the "Criteria" section?
I need the criteria to select black coloured text values, and ignore other
coloured text values.
Criteria does not allow me to use CONDITION FORMATTING as I used before.



"Dave" wrote:
Hi,
You could probably use SUMIF, and just use the same condition you used to
make the font black in the Cond Formatting.
Regards - Dave.- Hide quoted text -

- Show quoted text -

Hi,
You said you had 3 colours:
Red for negative
Blue and Back for positive.
In the Conditional Formatting:
What condition did you use to achieve black font?
What condition did you use to achieve blue font?
What condition did you use to achieve black font?
Is one of the font colours the default colour?
Dave.

Oops,
The first question should have asked about Red, not Black - sorry.
Dave.