View original (French)

Conditional Total Calculation Formula

Solved
Cloclem Posted messages 4 Status Membre -  
Cloclem Posted messages 4 Status Membre -

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 réponses

Réponse 1 / 2
bigoudiii Posted messages 276 Registration date   Status Membre Last intervention   91
 

Hello,

try in G3: =SUMIF($B$3:$B$405,F3,$D$3:$D$405), to be copied down
0
Réponse 2 / 2
Cloclem Posted messages 4 Status Membre
 

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