Forum Discussion

Jeremy ENGELEN's avatar
Jeremy ENGELEN
Copper Contributor
Jul 26, 2018
Solved

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 "...
excel
pranav trikha's avatar
pranav trikha
Brass Contributor
Jul 26, 2018

Greetings!

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

Please find attached file.

Thanks,

  • Jeremy ENGELEN's avatar
    Jeremy ENGELEN
    Copper Contributor
    Jul 26, 2018

    That's it!

    Thank you my good sir!

Resources