|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 24th 09, 04:31 PM
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??? 
|
| Ads |
|
#2
February 24th 09, 05:12 PM
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
February 24th 09, 05:13 PM
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
February 24th 09, 05:17 PM
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
February 24th 09, 05:20 PM
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
February 24th 09, 06:40 PM
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
February 24th 09, 07:10 PM
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???
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula to count number of time stamps within a range in a column having dates formatted as "custom" | Sam | Excel Discussion (Misc queries) | 3 | June 19th 07 12:33 AM |
| Count dates falling in a certain range | junoon | Excel Worksheet Functions | 6 | April 1st 06 02:22 AM |
| How do I get a count of dates within a range..? | cmharri123 | Excel Worksheet Functions | 2 | February 1st 06 11:22 AM |
| How do I count in a range of dates? | nancy | Excel Worksheet Functions | 2 | November 23rd 05 11:03 AM |
| How to count dates within a certain range in a column with mutiple date range entries | Krisjhn | Excel Worksheet Functions | 2 | September 1st 05 01:59 PM |
Linear Mode
