Fonction Somme Si Couleur

%3CLINGO-SUB%20id%3D%22lingo-sub-2035390%22%20slang%3D%22fr-FR%22%3ESum%20If%20Color%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2035390%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3EThe%20SommeSiCouleur%20function%20was%20activated%20until%20a%20few%20days%20earlier%20and%20since%20Excel%20no%20longer%20recognizes%20it%20and%20indicates%20%23NOM%3F.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20support%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2035390%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Bonjour , 

la fonction SommeSiCouleur etait activée jusqu'à quelques jours plut tôt et depuis Excel ne la reconnait plus et indique #NOM?.

 

Merci pour votre support 

 

cordialement 

5 Replies

@Marc_SE 

That's VBA function installed with some add-in or like. Perhaps here Fonction Excel : SOMME_SI_COULEUR (excel-pratique.com) you may find more details how to install it. Sorry, don't understand French.

@Sergei Baklan try google traduction

@frabra 

Sorry, not my business

@Marc_SE 

 

excel cannot sum by color unless you filter by color then subtotal the amounts, or if its a function then it's a vba solution that was created as a user defined function. ask the one who created it to fix it.

@Marc_SE 

With the permission of all involved,

although my knowledge is not on the same level as everyone posted before me,

but to clear up any misunderstandings what exactly is meant (which is most of my mistakes :),

I would recommend adding a file with these errors (please, without sensitive data )

so you can get an answer much faster and more precisely.

 

At the same time, it would be very helpful for anyone who would like to help,

because less time is needed to understand the problem ... so more time to solve it.

 

The possibilities in Excel are very diverse, including the errors that can be made with it, mostly without knowing it.

 

Here is a link that will help you to ask your question so that everyone involved who would like to help can also help.


Bienvenue dans votre espace de discussion Excel !

 

Thank you all for your understanding and patience

 

I wish us all a lot of fun with Excel :))