countif formula

[kumar1803]

Hello,

I have one column where i am tracking all my deals for number of days since online

Column A

# of days
8
15
4
2
0
-1

and so on so forth

I would like to count all my deals that are older that 8 and above. as you can see there are two deals that are equal to or older than 8 days

 

[Michael M]

Try

Excel 2007
	A
1	# of days
2	8
3	15
4	4
5	2
6	0
7	-1
8
9	2
Sheet1

Cell Formulas
Range	Formula
A9	=COUNTIF(A2:A7,">=8")

 

[kumar1803]

Thank you, It worked.