I am trying to write a formula that would count the number of calls in the last 15 days. Below is my formula. I am first looking at my date column so that it is in between today and 15 days ago. Then I need to only count for if the Type of Dealer (Single Select Drop Down) = DAP Dealer and Merchant if they are New and Onsite. I am receiving a the following error message - #INVALID Operation. What am I missing? I have looked at this formula and I don't see what I am missing.
=COUNTIFS(Date:Date, AND(@cell <= TODAY(), @cell > TODAY(-15)), AND([Type of Dealer]:[Type of Dealer] = "DAP Dealer", [Type of Dealer]:[Type of Dealer] = "Merchant"), [New / Existing]:[New / Existing], "New", [Activity Type]:[Activity Type], "Onsite")
Help Article Resources
Check out the Formula Handbook template!