View original (French)

Conditional Total Calculation Formula

Solved
Cloclem -  

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

    Hello,

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

    0
    1. Cloclem Author

      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