count if or sum if formula

[kumar1803]

Hello

I am trying to count all my past due deals by type

Column A (Type) Column B ( # of days)

Wholesale 8
5
9
2

Cash 9
5
4
1
8

Finance 2
3
5
8
0
-1

In a nutshell, I would like to count past due of any deals greater than or equal to 8 days above in column B by Type (column A)

 

[Peter_SSs]

Would this do?
Formula in C2 copied down to the end of the data. ($2000 in the formula should be greater than the number of rows you will ever have)

Excel Workbook
	A	B	C
1	Type	Days	No. >= 8
2	Wholesale	8	2
3		5
4		9
5		2
6
7	Cash	9	2
8		5
9		4
10		1
11		8
12
13	Finance	2	1
14		3
15		5
16		8
17		0
18		-1
19
kumar1803