Forum Discussion

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
Jul 26, 2018
Greetings!
As understood, have used COUNTIFS to sum criteria's.
Please find attached file.
Thanks,
Calculate.xlsx10 KB

SergeiBaklan

Diamond Contributor

Jul 26, 2018

Hi Jeremy,

You may use SUMIFS - https://support.office.com/en-us/article/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b

Jeremy ENGELEN
Copper Contributor
Jul 26, 2018
it didn't work but I just got the answer (bellow). Thanks for your time