Count if today and multiple criteria
My formula needs to read data from two columns with the combination of a CountIfs, Distinct, Today formula I think.
On row 16 in the count column, I want the cell to count how many entries are in the Amsterdam column when it is today's date. Row 2 shows today's date (16th March) and the formula should result in a count of 3. The 17th has 1 entry so should result in a count of 1.
If anyone has a solution, let me know!
Help Article Resources
Check out the Formula Handbook template!