How to count the number of times something occurs within a certain month

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

Hi,

Does anyone have a suggestion on how I should do the following?

I have a table column that contains dates like,

1 Feb 05
6 Feb 05
27 Feb 05
7 Mar 05
20 Mar 05

I want to be able to count Feb = 3 and Mar = 2.

Thanks!
Joyce
 
Hi Joyce

One way
=SUMPRODUCT(--(MONTH($A$1:$A$100)=2)
for February
Change to 3 for March etc. or put the Month number required in a cell and
refer to the cell
=SUMPRODUCT(--(MONTH($A$1:$A$100)=B1)

Regards

Roger Govier
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help with dates 2
count date occurances in range of dates... 2
Counting Entries by Month and Year 1
Count According to Date 1
Number of days in overlapping date ranges (using array formula?) 7
Specify a column by the month to calculate it's data 5
When building a chart Dates are been included that are not in thedate range 1
opposite of weighted average 4

Back
Top