Countif and an And!

vipa2000

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

Leibel S

@vipa2000

Seems like you need to use the COUNTIFS function:

=COUNTIFS([Target date for updates]:[Target date for updates],<=TODAY(),Actionee:Actionee, @cell="Jess Smith")

Leibel S

@vipa2000

Seems like you need to use the COUNTIFS function:

=COUNTIFS([Target date for updates]:[Target date for updates],<=TODAY(),Actionee:Actionee, @cell="Jess Smith")

vipa2000

Hi Leibel, thanks for that. I couldn't work out the need for the @cell ref when you have the column referencing as it is and so tried without: iIt works. Thank you.