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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!