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

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

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

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

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

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

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