Formula Question

T

thereclas

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
 
T

thereclas

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
 
P

Pete_UK

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
 
H

Harlan Grove

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

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