View original (French)

Total formula

Solved
cedric -  
Raymond PENTIER Posted messages 58216 Registration date   Status Contributor 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

3 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    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
    0
    1. cedric
       
      Désolé, je ne peux pas accéder à des liens externes. Veuillez fournir le texte à traduire directement ici.
      0
  2. Gyrus Posted messages 3360 Status Member 526
     
    Hello, 

    =SUMIF(B5:B17,"J",C5:C17)

    Same with "K" and "L".

    See you!
    0
    1. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
       
      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.
      0