count cells

[sugarbear]

hey trying to reference a value in a cell and count how many times that referenced cell appearsin a column of data. countif won't let me reference a cell. any help

 

[Zack Barresse]

Hi there,

Why won't it let you reference a cell?? What have you tried? How about ..


=COUNTIF(A:A,A1)


Where column A is the range of interest and A1 is the cell [value] you want to count.

 

[Von Pookie]

An example of what Zack is talking about:

Book1
	A	B	C	D
1	1		Find in list:	1
2	2
3	3		# of occurances:	4
4	2
5	3
6	4
7	1
8	2
9	1
10	1
Sheet1

 

[sugarbear]

ok .... yesterday it wouldnt work today it does I must have been making some simple mistake thanks guys