Countifs with special requirement
I need to use countifs to count the number of calls made to customers today.
In my example, Touch 1 and Touch 2 are calls today, however I also need some filtering with user input.
The criteria are as follow:
- Date equals to "Free Text Date" of 20/04/2020 (X1)
- Salesman equals to "Free Text Salesman" Peter (X2)
- Only Touch 1 and Touch 2 are considered as calls
I was trying =COUNTIFS(Stage:Stage, ("Touch 1" OR "Touch 2"), Salesman:Salesman ("X2"), Date:Date ("X1"))
X1 and X2 should be freely populated by users of the sheet without changing the code