Hopefully this is just a quick question, I swear I have done it
before...
I need to do a formula that will calculate all values in the cell range
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 right
thing. I actually have acceptable knowledge of excel for most everyday
types of uses.

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


--
thereclas
------------------------------------------------------------------------
thereclas's Profile: http://www.excelforum.com/member.php...o&userid=32645
View this thread: http://www.excelforum.com/showthread...hreadid=524508

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

Cheers,
--
AP

"thereclas" a écrit
dans le message de
...

Hopefully this is just a quick question, I swear I have done it
before...
I need to do a formula that will calculate all values in the cell range
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 right
thing. I actually have acceptable knowledge of excel for most everyday
types of uses.

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


--
thereclas
------------------------------------------------------------------------
thereclas's Profile:
http://www.excelforum.com/member.php...o&userid=32645
View this thread: http://www.excelforum.com/showthread...hreadid=524508

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


--
thereclas
------------------------------------------------------------------------
thereclas's Profile: http://www.excelforum.com/member.php...o&userid=32645
View this thread: http://www.excelforum.com/showthread...hreadid=524508

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

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").