How to COUNTIFS with DISTINCT dates and other range/criteria?
I am trying to write a COUNTIFS formula, taking into consideration of X criteria for a range of cells in addition to DISTINCT dates within Y range. Can anyone share any insight how to write this in a formula statement? I'll provide an example below.
I have a list entries in Smartsheet. They have dates associated with each entry. I want to count the # of entries that are indicated as "F2F (Face to Face)" interactions with customers. I also want to count it by month; therefore, want to count in a way that indicates "between October 1st 2023 to October 31st 2023" as an example. Some of these entries will have multiple F2F interactions on the same day (eg. Oct 10 2023) but I want to count these entries distinctively/uniquely - so those on the same day are not counted twice. How do I do this?
"Date" column has dates populated.
"Format" column has F2F indicated.
Much appreciated. Thank you!
Help Article Resources
Check out the Formula Handbook template!