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