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.

 How do I count a range of dates in a column?
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## How do I count a range of dates in a column?

#1
February 24th 09, 04:31 PM posted to microsoft.public.excel.worksheet.functions
 GBC external usenet poster Posts: 4
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
February 24th 09, 05:12 PM posted to microsoft.public.excel.worksheet.functions
 Dave Peterson external usenet poster Posts: 35,220
How do I count a range of dates in a column?

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
 Shane Devenshire[_2_] external usenet poster Posts: 3,346
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
 Dave Peterson external usenet poster Posts: 35,220
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
 GBC external usenet poster Posts: 4
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
 GBC external usenet poster Posts: 4
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
 T. Valko external usenet poster Posts: 15,768
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 Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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

All times are GMT +1. The time now is 08:00 AM.