Count for Data greater than a particular date range

[frnd4kumar]

[TABLE="width: 329"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Stages[/TD]
[TD]Date[/TD]
[TD]Volume[/TD]
[TD]Curr[/TD]
[/TR]
[TR]
[TD]Kumar[/TD]
[TD]Needs[/TD]
[TD="align: right"]11-09-2012[/TD]
[TD="align: right"]2600[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Sourav[/TD]
[TD]Implementation[/TD]
[TD="align: right"]11-09-2012[/TD]
[TD="align: right"]5000[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Akhil[/TD]
[TD]Implementation[/TD]
[TD="align: right"]04-09-2012[/TD]
[TD="align: right"]14500[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Murugan[/TD]
[TD]Implementation[/TD]
[TD="align: right"]24-09-2012[/TD]
[TD="align: right"]12000[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Sashankh[/TD]
[TD]Implementation[/TD]
[TD="align: right"]28-02-2013[/TD]
[TD="align: right"]400[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Arif[/TD]
[TD]Implementation[/TD]
[TD="align: right"]02-04-2013[/TD]
[TD="align: right"]125[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Kumar[/TD]
[TD]Needs[/TD]
[TD="align: right"]24-06-2012[/TD]
[TD="align: right"]500[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Arif[/TD]
[TD]Implementation[/TD]
[TD="align: right"]28-02-2013[/TD]
[TD="align: right"]1100[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Krishna[/TD]
[TD]Implementation[/TD]
[TD="align: right"]02-04-2013[/TD]
[TD="align: right"]0[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Sashankh[/TD]
[TD]Options[/TD]
[TD="align: right"]02-04-2013[/TD]
[TD="align: right"]100[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Sourav[/TD]
[TD]Options[/TD]
[TD="align: right"]01-03-2012[/TD]
[TD="align: right"]600[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Kumar[/TD]
[TD]Needs[/TD]
[TD="align: right"]02-08-2012[/TD]
[TD="align: right"]100[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Murugan[/TD]
[TD]Concerns[/TD]
[TD="align: right"]09-01-2013[/TD]
[TD="align: right"]75[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Arif[/TD]
[TD]Decision[/TD]
[TD="align: right"]02-01-2013[/TD]
[TD="align: right"]170[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Kumar[/TD]
[TD]Implementation[/TD]
[TD="align: right"]02-04-2013[/TD]
[TD="align: right"]450[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Arif[/TD]
[TD]Options[/TD]
[TD="align: right"]06-01-2013[/TD]
[TD="align: right"]1350[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Sourav[/TD]
[TD]Implementation[/TD]
[TD="align: right"]20-01-2013[/TD]
[TD="align: right"]5025[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Akhil[/TD]
[TD]Implementation[/TD]
[TD="align: right"]02-04-2013[/TD]
[TD="align: right"]140[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Murugan[/TD]
[TD]Options[/TD]
[TD="align: right"]23-03-2013[/TD]
[TD="align: right"]154[/TD]
[TD]INR[/TD]
[/TR]
[TR]
[TD]Sourav[/TD]
[TD]Implementation[/TD]
[TD="align: right"]28-09-2012[/TD]
[TD="align: right"]231[/TD]
[TD]INR[/TD]
[/TR]
</tbody><colgroup><col span="2"><col><col span="2"></colgroup>[/TABLE]

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