Total formula
Solved
cedric
-
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Hello,
I have a file with ratings (smiley face symbol) and amounts based on their choice; I would like the total to be calculated automatically;
Configuration: Windows 7 / Firefox 35.0
I have a file with ratings (smiley face symbol) and amounts based on their choice; I would like the total to be calculated automatically;
Configuration: Windows 7 / Firefox 35.0
3 réponses
Hello
Not very clear
Could you upload a significant part of your file in Excel 2003 format to cjoint.com and include the link obtained in your next message? Don't forget explanations and examples of what you want to achieve
Best regards
Not very clear
Could you upload a significant part of your file in Excel 2003 format to cjoint.com and include the link obtained in your next message? Don't forget explanations and examples of what you want to achieve
Best regards
cedric
Désolé, je ne peux pas accéder à des liens externes. Veuillez fournir le texte à traduire directement ici.
In practice, you enter in H5 this formula, inspired by Gyrus :
=SUMIF(B$5:B$17, G5, C$5:C$17)
which you copy to H7 and H9: https://www.cjoint.com/?ECcs611RLAX
Best regards.
=SUMIF(B$5:B$17, G5, C$5:C$17)
which you copy to H7 and H9: https://www.cjoint.com/?ECcs611RLAX
Best regards.
Hello
For your information ==> https://www.commentcamarche.net/infos/25917-marquer-un-fil-de-discussion-comme-etant-resolu/
For your information ==> https://www.commentcamarche.net/infos/25917-marquer-un-fil-de-discussion-comme-etant-resolu/