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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
something like this. Untested
=sumproduct((isdate(a2:a22))*(b2:b22="Y")) -- Don Guillett SalesAid Software "Pete" <Pete @discussions.microsoft.com wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Pete --
If you don't mind tying up another column -- You could just put an IF statement in a column and combine it with an AND statement. If both are true, have the cell output a "1" and then sum these on the bottom. Eric "Pete" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
=SUMPRODUCT((ISNONTEXT(B2:B22))*(D2:D22="d"))
-- Don Guillett SalesAid Software "Pete" <Pete @discussions.microsoft.com wrote in message ... 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 |
Reply |
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 |