Which Function to be used??

A

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
+-------------------------------------------------------------------
 
C

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.
Click to expand...

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
 
S

Spencer101

Asrar said:
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
Click to expand...

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

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
Top