Counting misc object in cells

's Computer Specifications

Hi,

hoping someone can shed some light on this.

I want to sum a column that contains the following symbol "•".

The following formula does not work.

=COUNTA(C5:C35, "•"), where "•" would count for 1, and an unfilled cell
equals 0.

Help appreciated.

regards, Nik

--
Ntisch
------------------------------------------------------------------------
Ntisch's Profile: http://www.excelforum.com/member.php...fo&userid=5791
View this thread: http://www.excelforum.com/showthread...hreadid=497774

's Computer Specifications

HI Nik

Try:

=COUNTIF(C5:C35,"•")

Regards
Shau

--
Shaun
-----------------------------------------------------------------------
ShaunM's Profile: http://www.excelforum.com/member.php...fo&userid=1861
View this thread: http://www.excelforum.com/showthread.php?threadid=49777

's Computer Specifications

Thanks Shaun - works a treat.

--
Ntisch
------------------------------------------------------------------------
Ntisch's Profile: http://www.excelforum.com/member.php...fo&userid=5791
View this thread: http://www.excelforum.com/showthread...hreadid=497774

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
counting highlighted cells or font color cells	Tired Dan	Microsoft Excel Discussion	0	10th Dec 2007 10:41 PM
How to create a view option (or hide/unhide preselected cells) (Repost from Misc)	Turquoise_dax	Microsoft Excel Programming	4	15th Jun 2006 08:45 PM
Complicated counting of cells (based on other cells contents)	=?Utf-8?B?R2Vvcmdl?=	Microsoft Excel Worksheet Functions	3	7th Nov 2005 06:39 PM
counting specific figures in cells dependant upon contents of adjacent cells	judoist	Microsoft Excel Discussion	2	15th Jun 2004 02:45 PM
Counting Number of Cells Including Merged Cells	Daniel D.	Microsoft Excel Worksheet Functions	12	24th Feb 2004 01:27 AM