SOLVED

Calculate SUM with three conditions

New Contributor

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

Capture.PNG

4 Replies
Best Response confirmed by Jeremy ENGELEN (New Contributor)
Solution

Greetings!

As understood, have used COUNTIFS to sum criteria's.

Please find attached file.

Thanks,

That's it!

Thank you my good sir!

it didn't work but I just got the answer (bellow). Thanks for your time