AND & COUNTIF in same formula

  • Thread starter Thread starter Manxy
  • Start date Start date
M

Manxy

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")
 
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---
 
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
 
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 criteri
=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. functio
=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?
=========================================
 
Back
Top