Which Function to be used??

[Asrar Ayub]

Hi All,

I have a sample data,
eg:
11/01/2012
11/01/2012
11/07/2012
11/07/2012
11/07/2012
11/07/2012
11/20/2012
11/20/2012
11/20/2012
11/20/2012

I want to know how many counts in November, not by Date. My Outpu
should say as "11" for the above example.

I have the excel spreadsheet for your kind reference.

Regards,
Asrar Ayu

+-------------------------------------------------------------------
|Filename: Sample Data.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=741
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Mon, 21 Jan 2013 07:25:09 +0000 schrieb Asrar Ayub:

11/01/2012
11/01/2012
11/07/2012
11/07/2012
11/07/2012
11/07/2012
11/20/2012
11/20/2012
11/20/2012
11/20/2012

I want to know how many counts in November, not by Date. My Output
should say as "11" for the above example.

you can do it with pivot table. Drag the dates into rows and into
values. Group the dates in the rows by month.
Or use in D4:
=IF(MONTH(C5)=MONTH(C4),"",SUMPRODUCT(--(MONTH($C$4:$C$100)=MONTH(C4)),--($C$4:$C$100<>"")))
and copy down


Regards
Claus Busch

 

[Spencer101]

Hi All,

I have a sample data,
eg:
11/01/2012
11/01/2012
11/07/2012
11/07/2012
11/07/2012
11/07/2012
11/20/2012
11/20/2012
11/20/2012
11/20/2012

I want to know how many counts in November, not by Date. My Outpu
should say as "11" for the above example.

I have the excel spreadsheet for your kind reference.

Regards,
Asrar Ayub

What do you mean by "not by Date"?
If you're counting dates, you need to involve dates...

+-------------------------------------------------------------------
+-------------------------------------------------------------------