If this is a conditional formatting criteria; add COUNTIF() as the 3rd
criteria within AND()

=AND(G3<€�€�,DATE(YEAR(G3)+1,MONTH(G3),DAY(G3)) <=TODAY(),COUNTIF(G3:G48,"N")=G50)

If this post helps click Yes
---------------
Jacob Skaria


"Manxy" wrote:

I have this formula previously stated on the forum which indicates when a
person is 1 year out of date

=AND(G3<€�€�,DATE(YEAR(G3)+1,MONTH(G3),DAY(G3)) <=TODAY())

Can I add a COUNTIF like that below to the equation so that the No cells add
up into cell G50?

=COUNTIF(G3:G48,"N")