countif formula

[kumar1803]

Hello,

Please help me build the count if formula based on criteria below:

1. I need to put a alert if any deal is over 2 days from contract date for TX state only
2. I need to put a alert if any deal is over 14 days from contract date for all other states.

[TABLE="width: 182"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Buyer State[/TD]
[TD]Contract Date
[/TD]
[/TR]
[TR]
[TD]TX[/TD]
[TD]11/2/2015[/TD]
[/TR]
[TR]
[TD]TX[/TD]
[TD]11/2/2015[/TD]
[/TR]
[TR]
[TD]TX[/TD]
[TD]11/2/2015[/TD]
[/TR]
[TR]
[TD]NV[/TD]
[TD]11/3/2015[/TD]
[/TR]
[TR]
[TD]OH[/TD]
[TD]11/3/2015[/TD]
[/TR]
</tbody>[/TABLE]


Thanks

 

[Caribeiro77]

Maybe:

Book1
	A	B	C	D	E
1	Buyer State	Contract Date
2	TX	01-01-2016		1. I need to put a alert if any deal is over 2 days from contract date for TX state only	2
3	TX	12-01-2016		2. I need to put a alert if any deal is over 14 days from contract date for all other states.	1
4	TX	01-01-2016
5	NV	12-12-2015
6	OH	11-01-2016
Sheet1

Cell Formulas
Range	Formula
E2	=COUNTIFS($A$2:$A$6,"TX",$B$2:$B$6,"<="&TODAY()-2)
E3	=COUNTIFS($A$2:$A$6,"<>"&"TX",$B$2:$B$6,"<="&TODAY()-14)

 

[kumar1803]

Thank you for formula. Can you please combine the formula in to one so i can use just one formula to find both value. may be use If formula.

 

[Aladin Akyurek]

Thank you for formula. Can you please combine the formula in to one so i can use just one formula to find both value. may be use If formula.

Perhaps...

C2, copied down:

=B2<=TODAY()-IF(A2="TX",2,14)