How to count numbers for specified customer in the specified month
Hello All,
am working on Excel and need help to know how I count the numbers that start with 120XXXXXX for the specified customer name (JOHN) in the month of September.
as you see in the photo, the Quotation Date (L) is in August but I need to calculate the quotation date in September only.
could you please help me with the right function?
Thank you.
Best Answer
-
If you are looking for help in Excel, you may want to try an Excel related forum.
Answers
-
If you are looking for help in Excel, you may want to try an Excel related forum.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 501 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 79 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
