Countif and an And!
Hi, got this far....
=COUNTIF(AND(Actionee:Actionee, "Jess Smith"), [Target date for updates]:[Target date for updates], <=TODAY())
Think I either have brackets or commas wrong! in essence count records where Actionee is Jess Smith and Target for updates column has date less than today.
Thanks in advance, Paul
Help Article Resources
Check out the Formula Handbook template!