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

  • Thread starter Thread starter GBC
  • Start date Start date
G

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???
 
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???
Click to expand...
 
Except that 2/1/2009 will be treated as a very small number greater than 0:

=2 divided by 1 divided by 2009.
 
Shane,
Thank You!!!!
That worked like a charm!!!

Shane Devenshire said:
Hi,

try

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire
Click to expand...
 
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?
 
=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))
 
Back
Top