Formula Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

thereclas - 20 Mar 2006 20:02 GMT

Hopefully this is just a quick question, I swear I have done i
before...
I need to do a formula that will calculate all values in the cell rang
that the text is not red.
Inquiries into excel help is not helping...
Books are not helping as I do not seem to be able to look up the righ
thing. I actually have acceptable knowledge of excel for most everyda
types of uses.

Thank you for your help, I am dying trying to remember this!
Meliss

Reply to this Message

Ardus Petus - 20 Mar 2006 20:54 GMT

You will need some VBA macro code for this. Do you mind?

Cheers,
--
AP

> Hopefully this is just a quick question, I swear I have done it
> before...
[quoted text clipped - 7 lines]
> Thank you for your help, I am dying trying to remember this!
> Melissa

Reply to this Message

thereclas - 20 Mar 2006 21:34 GMT

no I dont mind, but it sounds like there is not a simple formatting o
formula for it.
Whatever I can do to get this to work.
Thank yo

Reply to this Message

Pete_UK - 21 Mar 2006 00:07 GMT

Your question implies that there is conditional formatting applied to
the cell to turn it red, so if you know what formula is used in the
conditional format then it should be quite easy to reproduce this in
another formula to total those cells which do not meet the CF criteria.

To determine the CF formula, just select one of the cells and do Format

| Conditional formatting and make a note of the formula - can you post

it back here?

Hope this helps.

Pete

Reply to this Message

Harlan Grove - 21 Mar 2006 00:40 GMT

thereclas wrote...
...

>I need to do a formula that will calculate all values in the cell range
>that the text is not red.

...

Are the red values all negative values and all the non-red values zero
or positive values? If so, try =SUMIF(range,">0").

Reply to this Message