Creating a COUNTIFS formula to record number of quotes provided by a salesperson in a calendar month


Hello! When using COUNTIF formula in a summary sheet (referencing another sheet) to show number of jobs quoted per salesperson, as follows:

=COUNTIF({ASSIGNED TO}, [Primary Column]6) ..... where Primary Column shows the name of the salesperson

How would you write a COUNTIFS formula to read the Date Quoted column as well to display only quotes within a calendar month?

Thanks for your help!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!