Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
I am trying to count the number of cells that contain a Y in a particular
column IF the data in another column IS a date. I have tried a variation of the COUNTIF formula together with the AND function but it doesn't appear to like me using them together. Any ideas much appreciated. The date column is A cells 2:1528 and the Y or N appears in the X column also from cells 2:1528. please help! thanks Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |