COUNTIF the values is lesser than today's date
I would like to count the names with respective to dates in another column which is lesser than today's date.
I used the below formula:
=COUNTIFS([Projected CM1]:[Projected CM1], <=TODAY(), [CM1]:[CM1], "Flextronics Wuzhong CM")
But it doesn't give the right result, any leads please advise
Help Article Resources
Check out the Formula Handbook template!