Formula To Give Total Amount Of Times The Same Number Is In Column AE

[Dazzawm]

I need a Formula To Give The Total Amount Of Times The Same Number Is In Column AE please.

 

[RobP]

Book1
	AC	AD	AE	AF	AG	AH
1		4		5	(num to count)
2			4
3			6
4			7
5			5
6			3
7			2
8			2
9			3
10			4
11			5
12			8
13			5
14			5
Sheet1

Cell Formulas
Range	Formula
AD1	AD1	=COUNT(FILTER(AE:AE,AE:AE=AF1,0))

 

[Dazzawm]

Book1
	AC	AD	AE	AF	AG	AH
1		4		5	(num to count)
2			4
3			6
4			7
5			5
6			3
7			2
8			2
9			3
10			4
11			5
12			8
13			5
14			5
Sheet1

Cell Formulas
Range	Formula
AD1	AD1	=COUNT(FILTER(AE:AE,AE:AE=AF1,0))

Thanks but I am putting the formula in AI and it says 1 all the way down the list? (It needs to start in row 2 also).

 

[RobP]

where do you tell it which number you want to search for ? Do you put it in a cell, (like I put it in AF1) ?

thanks
Rob

 

[Dazzawm]

where do you tell it which number you want to search for ? Do you put it in a cell, (like I put it in AF1) ?

thanks
Rob

I am putting formula in AI2 and it needs to count the amount of times a number is in column AE starting row 2.

 

[RobP]

Yes, but "which" number ? How do you tell it which number it needs to look for ?

Rob

 

[RobP]

Maybe let me ask it in another way : What number are you trying to count in your list in AE ? Is it always that same number ?

thanks
Rob

 

[Dazzawm]

Maybe let me ask it in another way : What number are you trying to count in your list in AE ? Is it always that same number ?

thanks
Rob

No there are hundreds of different numbers, so I want to know how many times each unique number appears in the file.

 

[RobP]

Maybe this is what you are asking ? To check how many occurences of the corresponding number on that row is counted. So 4 for example below occurs 2 times in my list. 6 = 1 etc.

Book1
	AD	AE	AF	AG	AH	AI	AJ
1
2		4				2
3		6				1
4		7				1
5		5				4
6		3				2
7		2
8		2
9		3
10		4
11		5
12		8
13		5
14		5
15
Sheet1

Cell Formulas
Range	Formula
AI2:AI6	AI2	=COUNT(FILTER(AE:AE,AE:AE=AE2,0))

 

[Dazzawm]

Maybe this is what you are asking ? To check how many occurences of the corresponding number on that row is counted. So 4 for example below occurs 2 times in my list. 6 = 1 etc.

Book1
	AD	AE	AF	AG	AH	AI	AJ
1
2		4				2
3		6				1
4		7				1
5		5				4
6		3				2
7		2
8		2
9		3
10		4
11		5
12		8
13		5
14		5
15
Sheet1

Cell Formulas
Range	Formula
AI2:AI6	AI2	=COUNT(FILTER(AE:AE,AE:AE=AE2,0))

I am getting zero all the way down now.