Forum Discussion
Calculate SUM with three conditions
Hi,
I need to calcul the sum of cases won but for a specific sales rep and for a specific time.
What formula should I use?
Here I want to know how much "Cloturée/gagnée" I have in "2018" for the "XXX" sales rep
Thank you
Greetings!
As understood, have used COUNTIFS to sum criteria's.
Please find attached file.
Thanks,
Hi Jeremy,
You may use SUMIFS - https://support.office.com/en-us/article/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b
- it didn't work but I just got the answer (bellow). Thanks for your time
Greetings!
As understood, have used COUNTIFS to sum criteria's.
Please find attached file.
Thanks,
That's it!
Thank you my good sir!
