Say I have a column containing dates as below:
A B C
1 27 May 2003
2 03 Jun 2003
3 05 Jun 2003
4 22 Jun 2003
5 15 Jul 2003
6 10 Aug 2003
I want to count how many instances Jun 2003 is listed, regardless of the
day. I tried the COUNTIF worksheet function, but it only works if I
actually list the exact date, and then it only counts the instances
where that exact date is listed (example: =COUNTIF(A1:A6,"05 Jun 2003")
equals 1). Does anyone know of a formula that I can use that will count
how many instances a particular month/year appear in a huge
spreadsheet. In the example above I'm expecting the value to equal 3.
I tried using a wildcard (*) in place of the day number (example:
=COUNTIF(A1:A6,"* Jun 2003"), but I only get a return of zero. Help!
Thanks,
John
Frank Kabel - 08 Apr 2004 20:07 GMT
Hi
try
=SUMPRODUCT(--(YEAR(A1:A100)=2003),--(MONTH(A1:A100)=6))

Signature
Regards
Frank Kabel
Frankfurt, Germany
> Say I have a column containing dates as below:
>
[quoted text clipped - 20 lines]
>
> John
John - 08 Apr 2004 20:18 GMT
Frank, you are TOO GOOD!!!!! That's the 2nd time you've helped me out of
a jam. Thank you so much! Have a great Easter!
John
> Hi
> try
[quoted text clipped - 29 lines]
> >
> > John