Fromule de calcul

%3CLINGO-SUB%20id%3D%22lingo-sub-1463001%22%20slang%3D%22fr-FR%22%3EComputational%20fromula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1463001%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%2C%20in%20the%20spreadsheath%2C%20I%20would%20like%20to%20know%20if%20it%20is%20possible%20to%20make%20a%20formula%20that%20identifies%20text%20and%20applies%20a%20formula.%20Here%2C%20I%20would%20like%20when%20in%20the%20sheet%20%22Feuille34%22%2C%20the%20total%20under%20the%20categories%20%22Manutan%22%20%22Manusec%22%20Etc%2C%20take%20back%20the%20total%20of%20all%20Manusec%20or%20Manutant%20of%20the%20table%20TCD%20refresh%2C%20is%20it%20possible%3F%20This%20is%20in%20order%20to%20summarize%20the%20overall%20total%20orders%20at%20each%20supplier.%20The%20order%20of%20the%20TCD%20refresh%20is%20brought%20a%20change%2C%20it%20is%20for%20cella%20that%20I%20would%20like%20the%20reliability%20to%20be%20optimal%20and%20that%20the%20text%20is%20detected%20and%20not%20just%20the%20cell%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1463001%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1463031%22%20slang%3D%22en-US%22%3ERe%3A%20Fromule%20de%20calcul%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1463031%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F699481%22%20target%3D%22_blank%22%3E%40BenotP%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20understand.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20mean%20that%20if%20you%20add%20data%20to%20LISTING%20sheet%20you%20want%20the%20PIVOT%20TABLE%20on%20TCD%20sheet%20to%20be%20automatically%20be%20updated%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIncidentally%2C%20I%20cannot%20see%20a%20sheet%20called%20%3CSPAN%3E%22Feuille34%22%3F%20I%20see%20that%20you%20have%2030%20sheets%20hidden%20called%20%22Feuille%201%20to%2030%22%3C%2FSPAN%3E%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMore%20information%20please.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1463083%22%20slang%3D%22fr-FR%22%3ERe%3A%20Computing%20Fromule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1463083%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667968%22%20target%3D%22_blank%22%3E%40peteryac60%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attach%20a%20new%20binder%20with%20sheet%2034.%20In%20this%20sheet%2034%2C%20I%20wrote%20%22Manutan%22%20%22Manusec%22%2C%20%22Darty%22%20as%20an%20example.%20Under%20these%20categories%2C%20I%20wrote%20%22Total.%22%20Well%20I%20would%20like%20that%20instead%20of%20writing%20%22total%22%20there%20is%20a%20formula%20that%20will%20take%20in%20the%20sheet%20%22TCD%20REFRESH%22%20the%20overall%20total%20of%20each%20category.%20For%20example%2C%20I%20would%20like%20the%20formula%2C%20when%20it%20identifies%20%22Manutan%22%20to%20write%20in%20the%20G%20column%20of%20the%20refresh%20TCD%2C%20to%20make%20all%20the%20totals%20of%20the%20values%20of%20all%20the%20times%20manutan%20is%20written%20and%20that%20it%20defers%20it%20in%20sheet%2034%20under%20the%20manutan%20category%2C%20in%20the%20total%20tab.%20So%20that%20it%20is%20a%20general%20summary%20of%20all%20Manutan%20values.%20And%20if%20one%20of%20the%20manutant%20values%20changes%2C%20the%20total%20of%20sheet%2034%20changes%20as%20well.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20response.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Bonjour, dans le tableur que je vous joint, j'aimerais savoir si il est possible de faire une formule qui identifie du texte et y applique une formule. Ici, j'aimerai quand dans la feuille "Feuille34", le total sous les catégories "Manutan" "Manusec" Etc, reprennent le total de tout les Manusec ou Manutant du tableau TCD refresh, est-ce possible ? Ceci dans le but de faire un récapitulatif du total général des commandes chez chaque fournisseurs. L'ordre du TCD refresh est amené a change, c'est pour cella que j'aimerais que la fiabilité soit optimale et que le texte soit détecté et non juste la cellule

2 Replies
Highlighted

@BenotP 

 

I do not understand.

 

Do you mean that if you add data to LISTING sheet you want the PIVOT TABLE on TCD sheet to be automatically be updated?

 

Incidentally, I cannot see a sheet called "Feuille34"? I see that you have 30 sheets hidden called "Feuille 1 to 30"?

 

 

More information please.

Highlighted

@peteryac60 

 

Je vous joint un nouveau classeur qui comporte la feuille 34. Dans cette feuille 34, j'y ai écrit "Manutan" "Manusec", "Darty" comme exemple. Sous ces catégories, jy ai écris "Total". Et bien j'aimerai que à la place de l'écriture "total", il y ai une formule qui aille prendre dans la feuille "TCD REFRESH" le total général de chaque catégorie. Par exemple, j'aimerai que la formule, lorsqu'elle identifie "Manutan" ecris dans la colonne G du TCD refresh, elle en fasse tout les totaux des valeurs de toutes les fois ou il y a écris Manutan et qu'elle le reporte dans la feuille 34 sous la catégorie manutan, dans l'onglet total. De tel sorte que ce soit un récapitulatif général de toutes les valeurs Manutan. Et si une des valeurs manutant change, le total de la feuille 34 change aussi. 

 

Je vous remercie par avance pour votre réponse.