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???

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

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???

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

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???

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???

>=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" <(E-Mail Removed)> wrote in message
news:3987882F-C868-4C21-9867-(E-Mail Removed)...
> 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???