SUM only black numbers and leave out the RED ones
Jon wrote on Thu, 28 Feb 2008 17:16:22 -0500:
JP -Usually these criteria are manually applied.
Jon
P Is it possible to add a row tsaking into account all
P number written in black and to leave out the ones in red?
??
P I hope so ,this would be very helpfull. Also my excel is
P in french so if you know the french terminology that would
P help alot, but please reight to me in english.
??
?? To take a contrarian approach, some criterion must have
?? been used to get the red color. Could that not be
?? incorporated in a SUMIF function?
??
Is that so! Not meant sarcastically but I only use a numerical
criterion concerning standard deviations to high-light in red.
There is also the Number format using a different color for
negative numbers.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not
|