How to count multiple values in a single cell, except zero?

		Microsoft Office Forums > Microsoft Excel > Excel
How to count multiple values in a single cell, except zero?

FAQ

Thread Tools

Display Modes

04-13-2011, 09:35 PM

iuliandonici iuliandonici is offline

Windows XP How to count multiple values in a single cell, except zero?

Office 2007

Novice

Join Date: Apr 2011

Posts: 4

How to count multiple values in a single cell, except zero?

I have a cell that has multiple values, separated by ";". For example: "35; 255; 67; 0". In the next cell, I would like to know how can I count these values, except zero. Count not SUM them.

This single cell, can have up to 50 values and each value can have up to 7 digits.

I have looked up for COUNT, COUNTA, COUNTIF functions but didn't find any relevancy to what I'm trying to do. Can you, please help me?

Tags

count multiple, multiple values, single cell

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM
Count with multiple conditions	bundy5150	Excel	4	02-22-2011 10:00 AM
How can I write the following (whole) formula in a single cell?	Learner7	Excel	1	07-19-2010 10:06 AM
Pasting multiple photos - one photo per cell in a single oepration	mccruise	Word	0	04-07-2010 04:13 AM
multiple colums under a single column	RobotChicken	Excel	3	01-06-2010 09:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:43 AM.