Jul 26 2018 06:11 AM
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
Jul 26 2018 06:26 AM
Hi Jeremy,
You may use SUMIFS - https://support.office.com/en-us/article/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b
Jul 26 2018 06:32 AM
SolutionGreetings!
As understood, have used COUNTIFS to sum criteria's.
Please find attached file.
Thanks,
Jul 26 2018 06:41 AM
Jul 26 2018 06:32 AM
SolutionGreetings!
As understood, have used COUNTIFS to sum criteria's.
Please find attached file.
Thanks,