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