Help in COUNTIF.[SOLVED]

[bhasoriya]

In a column, there are many dates. I want to count it month wise.


For example in column A:

24-Jan-13

24-Jan-13

31-Jan-13

31-Jan-13

7-Feb-13

7-Feb-13

14-Feb-13

14-Feb-13


want to count how many dates are from January, feb...


Please guide me.

 

[Colin Legg]

A good way would be to use a pivot table.


If you don't have one, add a column header in the first row. Let's suppose you use the header "Dates".

Create a pivot table which refers to your data (including the header row).

Add "Dates" to both the row labels and the Values sections of the pivot table.

Ensure that the "Dates" field in the Values section is configured to give a Count.

Right click on the "Dates" in the Row Labels section > Group and group by Months and Years.

 

[bhasoriya]

Thanks Colin Legg, your idea is good. But actually, i want formula for this. I want to make merged formula and this is the part of it.. Thanks.

 

[NARAYANK991]

Hi Bhasoriya ,


Try this :


=SUMPRODUCT(--(TEXT(list_of_dates,"mmm")="Jan"))


Changing "Jan" to "Feb" , "Mar" , and so on will give you the count for the other months.


Narayan

 

[bhasoriya]

Thanks Narayank991.. this is the exact what i want... Thanks a lot..