Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED | Excel Worksheet Functions | |||
Formula Help (countif, I think....) | Excel Discussion (Misc queries) | |||
COUNTIF Formula | Excel Programming | |||
Formula Countif | Excel Discussion (Misc queries) | |||
CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions |