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