Count output for a range of date

[vaidmohammed]

Hi,
I want a formula where I can get COUNT of specified range for the dates range define by me.

01-Jan-17 A
02-Jan-17 B
03-Jan-17 C
04-Jan-17 D
05-Jan-17 E

From
To
01-Jan-17 03-Jan-17
04-Jan-17 05-Jan-17

I need a formula which gives me value 3 and 2 respectively in above given 2 date ranges.

 

[NARAYANK991]

Hi ,

Will the dates range have duplicate dates ?

Will the other column , what ever it is , have duplicates ?

Do you want to count duplicates or exclude them ?

Upload a proper workbook which has realistic data , instead of posting such simplistic sample data.

Narayan

 

[vaidmohammed]

Will the dates range have duplicate dates ?
NO
Will the other column , what ever it is , have duplicates ?
NO
Do you want to count duplicates or exclude them ?
NO
Upload a proper workbook which has realistic data , instead of posting such simplistic sample data.

 

[rahulshewale1]

Hiii ,

Use below formula formula ..
=COUNTIFS($C$1:$C$11,$A$15,$B$1:$B$11,">="&B15,$B$1:$B$11,"<="&C15)
Or
=COUNTIFS($C$1:$C$11,"PR",$B$1:$B$11,">="&B15,$B$1:$B$11,"<="&C15)

Regard
Rahul Shewale

 

[vaidmohammed]

Hi, I tried using advised formula in my actual sheet but unable to get expected results. (I changed cell references and ranges accordingly)
Attached is the one file, where I want it working.

The actual file expectations :
I need this formula to work in attached excel's PPM sheet in row no. 3 for the respective date ranges defined in row no. 2.

The data is in sheet Details. Col. I is the column from where date range is to be looked in and Column P is the column where we need to take count of Problem Report, in respect to date range.

 

[NARAYANK991]

Hi ,

Shouldn't the formula be :

=COUNTIFS(Details!$P:$P,"Problem Report",Details!$I:$I,">="&B$2,Details!$I:$I,"<="&C$2)

Narayan