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

[GBC]

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]

Check your earlier post.

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

 

[Shane Devenshire]

Hi,

try

=SUMPRODUCT(--(H3:H58="ICO"),--(E3:E58>=2/1/2009))

 

[Dave Peterson]

Except that 2/1/2009 will be treated as a very small number greater than 0:

=2 divided by 1 divided by 2009.

 

[GBC]

Shane,
Thank You!!!!
That worked like a charm!!!

Hi,

try

=SUMPRODUCT(--(H3:H58="ICO"),--(E3:E58>=2/1/2009))

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[GBC]

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?

 

[T. Valko]

=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))