Simple COUNTIF problem

[Keithflc]

Hi all,

I've been wrestling with this problem for an hour now and trawled through this forum to no avail. Basically I want to count the number of occurrences of the month and year, ie 08/2012

I've attached the a test sheet with the problem, the formula =COUNTIF(A1:A2,"May 2012") , it works with dates that start with 01/, but not dates greater than 01 (i.e 01/05/2012 but not 02/05/2012). Any ideas? It's probably something really silly that I'm not seeing. Any advice gratefully received.

[dinesh_ltjd]

Hi,

I have insterted a column and then applied Countif formula...

See if this work else let me know

Thanks
Dinesh

[Kevin UK]

Hi Keithflc

Try the following COUNTIFS

Please Login or Register  to view this content.

[Keithflc]

Both of these solutions worked, thanks so much! I've no idea how Kevin's one works, but that doesn't matter.

I'll just need to figure out which one is quicker to implement

[Kevin UK]

Hi Keithflc

You do not need a helper column!
Lots of ways to do it with COUNTIFS or SUMPRODUCT

Please Login or Register  to view this content.

If you put your dates in cells you can reference the in your formulas. IE: In cell F1 the start date:01/08/2012 & F2 the end date: 31/08/2012
=COUNTIFS(A1:A2,">="&F1,A1:A2,"<="&F2)

[Kevin UK]

Hi

I did not notice you uploaded a file. See the attached.

[Keithflc]

Thanks Kevin