SOLVED

Calculate SUM with three conditions

Copper 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 (Copper 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
1 best response

Accepted Solutions
best response confirmed by Jeremy ENGELEN (Copper Contributor)
Solution

Greetings!

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

Please find attached file.

Thanks,

View solution in original post