Counting number of occurances in a month

[surkdidat]

I am creating a spreadsheet with data on sheet called "MAIN" and a seperate sheet called "SUMMARY"

On sheet MAIN - column A contains a date in dd/mm/yy format. I need a formula to put into a cell in SUMMARY worksheet that will count the number of cells in column H that are from a particaular month, ie I will have 12 cells, one for Jan, one for Feb etc etc, and I need it to count the number of instances per month (ideally Oct 2011, November 2011, December 2011, January 2012) etc so when we start the new year it does not mix up 2011 and 2012 data

Can anyone help?

I have tried adding a column next to it, and running a COUNTIF command but that does not seem to work

 

[Andrew Poulsom]

You can use a formula like:

=SUMPRODUCT(--(TEXT(MAIN!A1:A100,"mm-yyyy")=TEXT(A1,"mm-yyyy")))

 

[surkdidat]

Hiya, this is bringing up random numbers! (Its column H not A, but have substituted this) - with regards to the second part of the formula when it just has A1 this is selecting a cell on the SUMMARY sheet- is this correct or is that where the problem lies.