AND & COUNTIF in same formula
 

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")

AND & COUNTIF in same formula
 

The function you posted contained only the first argument, I suspect the
second is the Count function... If so, try this:
=IF(AND(G3<"",DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))< =TODAY()),COUNTIF(G3:G48,"N"),"")

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"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")

AND & COUNTIF in same formula
 

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")

AND & COUNTIF in same formula
 

I can't seem to get this to work and would appreciate your patience by going
through this with me please.
My original Cond. Form was placed into cell G3 as below
=AND(G3<€�€�,DATE(YEAR(G3)+1,MONTH(G3),DAY(G3)) <=TODAY())

I replaced that arguement with this conditional formatting, although I was
not sure what you meant by the third criteria
=AND(G3<€�€�,DATE(YEAR(G3)+1,MONTH(G3),DAY(G3)) <=TODAY(),COUNTIF(G3:G48,"N")=G50)

i have also tried this as well in cell G3 using the Cond. Form. function
=IF(AND(G3<"",DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))< =TODAY()),COUNTIF(G3:G48,"N"),"")

Am I putting either formula in the right place?
If not, where?
=========================================
"ryguy7272" wrote:

The function you posted contained only the first argument, I suspect the
second is the Count function... If so, try this:
=IF(AND(G3<"",DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))< =TODAY()),COUNTIF(G3:G48,"N"),"")

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"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")