View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pascale Pascale is offline
external usenet poster
 
Posts: 78
Default 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