|
|
#1
04-13-2011, 09:35 PM
|
|||
|
|||
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 |
|
|
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 |
Windows XP 
Office 2007
Threaded Mode