Thread: [Solved] How to count multiple values in a single cell, except zero?
View Single Post
 
Old 04-13-2011, 09:35 PM
iuliandonici iuliandonici is offline Windows XP Office 2007
Novice
  
Join Date: Apr 2011
Posts: 4
iuliandonici is on a distinguished road
Default 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?
Reply With Quote