| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to count the number of times something occurs within a certain month
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 |
|
#2
|
|||
|
|||
|
How to count the number of times something occurs within a certainmonth
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 Joyce wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the number of Cells in one ROW with conditions | Excel Worksheet Functions | |||
| Count number of items by month | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
| PivotTable - Count by Month | Excel Worksheet Functions | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
Linear Mode
