Count no of dates

[Ranjjeetk]

I have data

Demo4.xls
	A	B	C	D	E	F	G	H
1	TicketNumber+	Impact	CreatedBy	Assigned-to	AssignTime	WIPTime	ClosedTime	Status
2	2917288	Medium	ci655	KhopdeRanjjeet	6/1/200621:21			PendingInfo
3	2894043	Medium	cs730	KhopdeRanjjeet	5/19/200619:03		5/25/200620:08	Closed
4	2698598	Medium	fz536	KhopdeRanjjeet	2/20/200614:31		4/18/200615:24	Closed
5	2686476	Medium	cd856	KhopdeRanjjeet	2/20/20063:59		2/20/20068:25	Closed
6	2593645	Medium	ay329	KhopdeRanjjeet	2/20/200614:07	12/8/200523:23	3/15/200616:29	Closed
7	2623070	Medium	cv056	KhopdeRanjjeet	3/7/200617:50	12/27/200519:38	5/3/200615:57	Closed
8	2622551	Medium	cv056	KhopdeRanjjeet	3/7/200617:50	12/27/200519:39	5/3/20066:29	Closed
Discoverer Data

And data I required should populate in

Demo4.xls
	A	B	C	D	E
4	FromDate	ToDate	TicketsAssigned	Closed	WIP
5	08-Oct-05	14-Oct-05
6	15-Oct-05	21-Oct-05
7	22-Oct-05	28-Oct-05
Stats

In second excel from date and to date contains the dates and under Ticket Assigned I should get count from excel 1 (Col Assign_time) count of ticket between those two dates. Kindly suggest.

 

[NBVC]

Just change the = signs to <> signs in the last 2 arguments.


Edit:

You will also have to change the sign between the last 2 arguments to * again since you are now performing and AND not an OR.

 

[Ranjjeetk]

if we put as <> for its adding twice .

eg +SUMPRODUCT((a>=A5)*(a<=B5+1)*((racfid<>"fz541")+(racfid<>"gf446")))

In above formula )*((racfid<>"fz541")+(racfid<>"gf446") is able to find result 10 + 10 and giving result 20

it should give resullt as 10

 

[NBVC]

Please look at the EDIT in my last post. Change the + to *