View original (French)

Conditional Total Calculation Formula

Solved
Cloclem Posted messages 4 Status Member -  
Cloclem Posted messages 4 Status Member -

Hello everyone, 

I hope you're doing well! I really need help to create a formula. I imagine for the more experienced among you, it will be very easy, but for me, as a novice, it seems like a huge headache... Especially since it's for a game, so it frustrates me to spend so much time worrying about it haha

I want to find a formula that can automatically calculate the total revenue per hairdresser in cells G3:G8

I'm sharing the link to my file on Google Sheets: https://docs.google.com/spreadsheets/d/1Opz-i_b6lv2Wqyf2BY_z-YV0PbnQx6CoBUwAhLf1Jr4/edit?usp=sharing

Thank you all for your help! 


2 answers

  1.
    bigoudiii Posted messages 276 Registration date   Status Member Last intervention   91
     

    Hello,

    try in G3: =SUMIF($B$3:$B$405,F3,$D$3:$D$405), to be copied down

    0
  2. Cloclem Posted messages 4 Status Member
     

    Hello!
    I don't know who helped me, but it's amazing!
    Thank you for your help! I wouldn't have been able to do this!

    Thanks again!

    0