count cells

sugarbear

New Member
Joined
Jul 30, 2004
Messages
27
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
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
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

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
An example of what Zack is talking about:
Book1
ABCD
11Find in list:1
22
33# of occurances:4
42
53
64
71
82
91
101
Sheet1
 

sugarbear

New Member
Joined
Jul 30, 2004
Messages
27
ok .... yesterday it wouldnt work today it does I must have been making some simple mistake :oops: thanks guys
 

Watch MrExcel Video

Forum statistics

Threads
1,118,029
Messages
5,569,747
Members
412,289
Latest member
Kingchaos64
Top