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.
Thanks
Best Answer
-
Hi this should work, you would need to align your column names to what they actually are in your sheet. This would give you the total of closed deals for Region 1, I would then make a new cell for Region 2...3..4 and so on and then just do a =SUM( for all the totals for each region just so you could see each one individually and then a total.
=COUNTIFS([Region Column:Region Column], "Region 1", [Deal Status:Deal Status], "Closed Deal", [Date Colmn:Date Column], YEAR(@cell) = 2020)
Hope that helps.
Answers
-
Hi this should work, you would need to align your column names to what they actually are in your sheet. This would give you the total of closed deals for Region 1, I would then make a new cell for Region 2...3..4 and so on and then just do a =SUM( for all the totals for each region just so you could see each one individually and then a total.
=COUNTIFS([Region Column:Region Column], "Region 1", [Deal Status:Deal Status], "Closed Deal", [Date Colmn:Date Column], YEAR(@cell) = 2020)
Hope that helps.
-
Thank you - this fixed it.
-
Awesome glad I could help
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives