Help using COUNTIF

[Sean15]

Hi:
I am trying to count rows of data in column A. If count is less than 10, then $B$2/$B$3, if count is more than 10, return ""
Formula in column B is not returning the required value. Could you help please

Regards,
Sean

Book1
	A	B	C
1
2		150,000.00
3		10.00
4
5
6			Required value
7	6/1/2021		15,000.00
8	7/1/2021		15,000.00
9	8/1/2021		15,000.00
10	9/1/2021		15,000.00
11	10/1/2021		15,000.00
12	11/1/2021		15,000.00
13	12/1/2021		15,000.00
14	1/1/2022		15,000.00
15	2/1/2022		15,000.00
16	3/1/2022		15,000.00
17	4/1/2022
18	5/1/2022
19	6/1/2022
20	7/1/2022
21	8/1/2022
22			150,000.00
Sheet1

Cell Formulas
Range	Formula
B7:B21	B7	=IF(COUNTIF($A$7:$A8,">10"),"",$B$2/$B$3)
C22	C22	=SUM(C7:C21)

 

[Fluff]

How about

=IF(COUNT($A$7:$A7)>10,"",$B$2/$B$3)