Question

[locodice]

I have a column with various dates in e.g. 1/4/08 etc. Does anyone know a formula where I can count how many times each month of the year appears in the coloumn?

And, if there is column next to the dates one with cases in e.g. EF1, can I count how many times a case appears in each month of the year?

Any help will be great?

 

[iliace]

=SUMPRODUCT(--(MONTH(A1:A100)=1))

Will count number of cells in A1:A100 are dates with the month of January.

 

[locodice]

Thanks. I take it if I put 2 instead of 1 it would count february and so on? I'm new to this.

 

[iliace]

Yes, the formula will generate an array of months 1 through 12, the size of your range (100 values for A1:A100). It then compares each to the given number, which in my example is 1. Finally, it sums 1 for each comparison returning true, giving you the number of dates of that month.