S sugarbear New Member Joined Jul 30, 2004 Messages 27 Nov 16, 2005 #1 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
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 MrExcel MVP Joined Dec 9, 2003 Messages 10,881 Office Version 3652010 Platform WindowsMobileWeb Nov 16, 2005 #2 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.
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 Nov 16, 2005 #3 An example of what Zack is talking about:Book1ABCD11Find in list:12233# of occurances:4425364718291101Sheet1
An example of what Zack is talking about:Book1ABCD11Find in list:12233# of occurances:4425364718291101Sheet1
S sugarbear New Member Joined Jul 30, 2004 Messages 27 Nov 16, 2005 #4 ok .... yesterday it wouldnt work today it does I must have been making some simple mistake thanks guys
ok .... yesterday it wouldnt work today it does I must have been making some simple mistake thanks guys