Countif

[ttratl]

Hi All,

Is there an easy way of counting the number of instances certain dates appear in a range?

I am using this formula:
{=(COUNTIF(LABS!$A$5:$A$21,">=1/5/2006")-COUNTIF(LABS!$A$5:$A$21,">=1/6/2006"))}
to count the number of times any date in May 2006 appears in the range.

It seems overly complicated!

Any suggestions?

 

[Peter_SSs]

ttratl

Here is another suggestion, but it is not much (if any) simpler than your solution:
=SUMPRODUCT(--(MONTH(LABS!$A$5:$A$21)=5),--(YEAR(LABS!$A$5:$A$21)=2006))

 

[Brian from Maui]

Hi All,

Is there an easy way of counting the number of instances certain dates appear in a range?

I am using this formula:
{=(COUNTIF(LABS!$A$5:$A$21,">=1/5/2006")-COUNTIF(LABS!$A$5:$A$21,">=1/6/2006"))}
to count the number of times any date in May 2006 appears in the range.

It seems overly complicated!

Any suggestions?

Not sure what you mean by overly complicated, but entered with just Enter

=SUMPRODUCT(($A$5:$A$21-DAY($A$5:$A$21)+1=$B1)+0)

Where B1 houses the first day of the month you're trying to count.

 

[barry houdini]

...or

=SUMPRODUCT(--(TEXT(Labs!$A$5:$A$21,"m-yy")="5-06"))

 

[ttratl]

Thanks everyone!