Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM only black numbers and leave out the RED ones
Hello again,
Is it possible to add a row tsaking into account all number written in black and to leave out the ones in red? I hope so ,this would be very helpfull. Also my excel is in french so if you know the french terminology that would help alot, but please reight to me in english. Take care Pascale |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM only black numbers and leave out the RED ones
Have a look here
http://www.cpearson.com/excel/colors.htm Mike "Pascale" wrote: Hello again, Is it possible to add a row tsaking into account all number written in black and to leave out the ones in red? I hope so ,this would be very helpfull. Also my excel is in french so if you know the french terminology that would help alot, but please reight to me in english. Take care Pascale |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM only black numbers and leave out the RED ones
hi
see this site for functions on working with colors. count, sum, sort, etc. background or fonts. http://cpearson.com/excel/colors.htm regards FSt1 "Pascale" wrote: Hello again, Is it possible to add a row tsaking into account all number written in black and to leave out the ones in red? I hope so ,this would be very helpfull. Also my excel is in french so if you know the french terminology that would help alot, but please reight to me in english. Take care Pascale |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM only black numbers and leave out the RED ones
Wow I wasn't expecting this, with a bit of concentration thought I should
manage, but do you have this same site now in french? "FSt1" wrote: hi see this site for functions on working with colors. count, sum, sort, etc. background or fonts. http://cpearson.com/excel/colors.htm regards FSt1 "Pascale" wrote: Hello again, Is it possible to add a row tsaking into account all number written in black and to leave out the ones in red? I hope so ,this would be very helpfull. Also my excel is in french so if you know the french terminology that would help alot, but please reight to me in english. Take care Pascale |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM only black numbers and leave out the RED ones
hi
no. i don't. sorry Regards FSt1 "Pascale" wrote: Wow I wasn't expecting this, with a bit of concentration thought I should manage, but do you have this same site now in french? "FSt1" wrote: hi see this site for functions on working with colors. count, sum, sort, etc. background or fonts. http://cpearson.com/excel/colors.htm regards FSt1 "Pascale" wrote: Hello again, Is it possible to add a row tsaking into account all number written in black and to leave out the ones in red? I hope so ,this would be very helpfull. Also my excel is in french so if you know the french terminology that would help alot, but please reight to me in english. Take care Pascale |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM only black numbers and leave out the RED ones
Pascale wrote on Thu, 28 Feb 2008 04:52:01 -0800:
P Is it possible to add a row tsaking into account all number P written in black and to leave out the ones in red? P I hope so ,this would be very helpfull. Also my excel is in P french so if you know the french terminology that would help P 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? James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM only black numbers and leave out the RED ones
Maybe someone in the French Excel groups would know of a French resource.
Gord Dibben MS Excel MVP On Thu, 28 Feb 2008 05:57:02 -0800, Pascale wrote: Wow I wasn't expecting this, with a bit of concentration thought I should manage, but do you have this same site now in french? "FSt1" wrote: hi see this site for functions on working with colors. count, sum, sort, etc. background or fonts. http://cpearson.com/excel/colors.htm regards FSt1 "Pascale" wrote: Hello again, Is it possible to add a row tsaking into account all number written in black and to leave out the ones in red? I hope so ,this would be very helpfull. Also my excel is in french so if you know the french terminology that would help alot, but please reight to me in english. Take care Pascale |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM only black numbers and leave out the RED ones
If your black numbers are positive, and your red numbers are negative, then
you can simply use Sumif greater than zero. Regards, Fred. "Pascale" wrote in message ... Hello again, Is it possible to add a row tsaking into account all number written in black and to leave out the ones in red? I hope so ,this would be very helpfull. Also my excel is in french so if you know the french terminology that would help alot, but please reight to me in english. Take care Pascale |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM only black numbers and leave out the RED ones
Usually these criteria are manually applied.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "James Silverton" wrote in message ... Pascale wrote on Thu, 28 Feb 2008 04:52:01 -0800: P Is it possible to add a row tsaking into account all number P written in black and to leave out the ones in red? P I hope so ,this would be very helpfull. Also my excel is in P french so if you know the french terminology that would help P 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? James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM only black numbers and leave out the RED ones
"James Silverton" wrote in message ... Jon wrote on Thu, 28 Feb 2008 17:16:22 -0500: JP -Usually these criteria are manually applied. 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. I was thinking of so many of the cases of actual human usage I've observed. Conditional Formatting? What's that? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM only black numbers and leave out the RED ones
Jon wrote on Thu, 28 Feb 2008 19:48:00 -0500:
JP "James Silverton" wrote in JP message ... ?? Jon wrote on Thu, 28 Feb 2008 17:16:22 -0500: ?? JP -Usually these criteria are manually applied. ?? ?? 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. JP I was thinking of so many of the cases of actual human JP usage I've observed. Conditional Formatting? What's that? Basically, as I indicated, I want large changes to stand out so I have things arranged so that if a change is more than 1.5 ESDs it is displayed in red. I'd call that "conditional formatting". James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM only black numbers and leave out the RED ones
"James Silverton" wrote in message ... Jon wrote on Thu, 28 Feb 2008 19:48:00 -0500: JP "James Silverton" wrote in JP message ... ?? Jon wrote on Thu, 28 Feb 2008 17:16:22 -0500: ?? JP -Usually these criteria are manually applied. ?? ?? 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. JP I was thinking of so many of the cases of actual human JP usage I've observed. Conditional Formatting? What's that? Basically, as I indicated, I want large changes to stand out so I have things arranged so that if a change is more than 1.5 ESDs it is displayed in red. I'd call that "conditional formatting". I guess you missed my sarcasm. You will find many people that manually change formatting, cell by cell. They've never heard of Conditional Formatting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The numbers I enter are changed when I leave the cell | Excel Discussion (Misc queries) | |||
Searching for numbers, do I enter the , or leave it out? | Excel Discussion (Misc queries) | |||
Leave Log | Excel Discussion (Misc queries) | |||
Line numbers some numbers are blue some are black | Excel Discussion (Misc queries) | |||
Help: Pasted red numbers turn black | Charts and Charting in Excel |