| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count a range of dates in a column?
How can I count a range of dates in one column and that range has to include
specific text in another column? =COUNTA((E3:E58="2/1/2009")*AND(H3:H58="ICO")) Am I using the wrong formula??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a range of dates in a column?
Check your earlier post.
GBC wrote: How can I count a range of dates in one column and that range has to include specific text in another column? =COUNTA((E3:E58="2/1/2009")*AND(H3:H58="ICO")) Am I using the wrong formula??? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a range of dates in a column?
Hi,
try =SUMPRODUCT(--(H3:H58="ICO"),--(E3:E58=2/1/2009)) -- If this helps, please click the Yes button Cheers, Shane Devenshire "GBC" wrote: How can I count a range of dates in one column and that range has to include specific text in another column? =COUNTA((E3:E58="2/1/2009")*AND(H3:H58="ICO")) Am I using the wrong formula??? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a range of dates in a column?
Except that 2/1/2009 will be treated as a very small number greater than 0:
=2 divided by 1 divided by 2009. Shane Devenshire wrote: Hi, try =SUMPRODUCT(--(H3:H58="ICO"),--(E3:E58=2/1/2009)) -- If this helps, please click the Yes button Cheers, Shane Devenshire "GBC" wrote: How can I count a range of dates in one column and that range has to include specific text in another column? =COUNTA((E3:E58="2/1/2009")*AND(H3:H58="ICO")) Am I using the wrong formula??? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a range of dates in a column?
Shane,
Thank You!!!! That worked like a charm!!! "Shane Devenshire" wrote: Hi, try =SUMPRODUCT(--(H3:H58="ICO"),--(E3:E58=2/1/2009)) -- If this helps, please click the Yes button Cheers, Shane Devenshire "GBC" wrote: How can I count a range of dates in one column and that range has to include specific text in another column? =COUNTA((E3:E58="2/1/2009")*AND(H3:H58="ICO")) Am I using the wrong formula??? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a range of dates in a column?
Hi Shane,
If I change the text to "wfo" instead of "ico" I am getting way too many results, I should only be getting 1, any thoughts on the problem? "Shane Devenshire" wrote: Hi, try =SUMPRODUCT(--(H3:H58="ICO"),--(E3:E58=2/1/2009)) -- If this helps, please click the Yes button Cheers, Shane Devenshire "GBC" wrote: How can I count a range of dates in one column and that range has to include specific text in another column? =COUNTA((E3:E58="2/1/2009")*AND(H3:H58="ICO")) Am I using the wrong formula??? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a range of dates in a column?
=SUMPRODUCT(--(H3:H58="ICO"),--(E3:E58=2/1/2009))
As Dave Peterson noted, that formula is incorrect. Use cells to hold your criteria: A1 = 2/1/2009 B1 = ICO =SUMPRODUCT(--(E3:E58=A1),--(H3:H58=B1)) -- Biff Microsoft Excel MVP "GBC" wrote in message ... Hi Shane, If I change the text to "wfo" instead of "ico" I am getting way too many results, I should only be getting 1, any thoughts on the problem? "Shane Devenshire" wrote: Hi, try =SUMPRODUCT(--(H3:H58="ICO"),--(E3:E58=2/1/2009)) -- If this helps, please click the Yes button Cheers, Shane Devenshire "GBC" wrote: How can I count a range of dates in one column and that range has to include specific text in another column? =COUNTA((E3:E58="2/1/2009")*AND(H3:H58="ICO")) Am I using the wrong formula??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count number of time stamps within a range in a column having dates formatted as "custom" | Excel Discussion (Misc queries) | |||
| Count dates falling in a certain range | Excel Worksheet Functions | |||
| How do I get a count of dates within a range..? | Excel Worksheet Functions | |||
| How do I count in a range of dates? | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Hybrid Mode
