How to Count My Closed Deals for the current year?

I need to be able to see how many deals we have closed this year for the various regions. i.e Region 1, Region 2, Region 3 for 2020. I have about 5 stages - closed deal is the last stage.

I was trying use this as part of my formula =COUNTIFS({Business Unit}, [Business Unit]@row1, {Stage}, Stage$9, "> ="&DATE(C2,1,1),dates,"<="&DATE(C2,12,31)) C2 is 2020

This is within a Metric sheet pulling other criteria into the formula as well.

I have to admit - just starting to use formulas and I feel like I'm drowning. Any help would be appreciated.


Best Answer


  • Deb White
    Deb White ✭✭✭✭

    Thank you - this fixed it.

  • Awesome glad I could help