COUNTIFS in a Date Range
I'm attempting to count how many times a sales rep's name appears in a column and the deal they're working on will be closed within a date range. I'm using a countifs statement with an AND for the criteria on the second range. I receive an INVALID OPERATION result when I use AND, but if I only look for either greater than or less than a date, the formula works. Please help!
=COUNTIFS([Sales Rep]:[Sales Rep], [Column50]@row, [Close Date]:[Close Date], AND(>=[Column53]1, <=[Column54]1))
[Column50]@row is the employee's name
[Column53]1 is the beginning of the date range
[Column54]1 is the end of the date range
Help Article Resources
Check out the Formula Handbook template!