Countifs with special requirement

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:

  1. Date equals to "Free Text Date" of 20/04/2020 (X1)
  2. Salesman equals to "Free Text Salesman" Peter (X2)
  3. 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


Sign In or Register to comment.