Count for Data greater than a particular date range

[frnd4kumar]

Name	Stages	Date	Volume	Curr
Kumar	Needs	11-09-2012	2600	INR
Sourav	Implementation	11-09-2012	5000	INR
Akhil	Implementation	04-09-2012	14500	INR
Murugan	Implementation	24-09-2012	12000	INR
Sashankh	Implementation	28-02-2013	400	INR
Arif	Implementation	02-04-2013	125	INR
Kumar	Needs	24-06-2012	500	INR
Arif	Implementation	28-02-2013	1100	INR
Krishna	Implementation	02-04-2013	0	INR
Sashankh	Options	02-04-2013	100	INR
Sourav	Options	01-03-2012	600	INR
Kumar	Needs	02-08-2012	100	INR
Murugan	Concerns	09-01-2013	75	INR
Arif	Decision	02-01-2013	170	INR
Kumar	Implementation	02-04-2013	450	INR
Arif	Options	06-01-2013	1350	INR
Sourav	Implementation	20-01-2013	5025	INR
Akhil	Implementation	02-04-2013	140	INR
Murugan	Options	23-03-2013	154	INR
Sourav	Implementation	28-09-2012	231	INR

<tbody>
</tbody><colgroup><col span="2"><col><col span="2"></colgroup>

For the Above data I would like to count (using a formula) Number of kumar in needs stage that is later than 2011.

 

[Eric Golf]

Hi,

Presuming your data is in A1:E21 then in:-
F2 enter Kumar
G2 enter Needs
H2 enter 31-Dec-13
I2 enter =COUNTIFS($A$2:$A$21,F2,$B$2:$B$21,G2,$C$2:$C$21,">"&H2)

Hope this helps

Eric

 

[frnd4kumar]

Thank you for the kind help

 

[Eric Golf]

You're welcome. Thanks for coming back.

Eric