software

I'm trying to find an Excel formula which will give me the total number
of entries in a range.1-4 should provide 4
2 should provide 1
345 should provide 1
1-17 should provide 17
13-23 should provide 11

So the actual value of the number is not important but I need to return
the number in the range of values.
Any help much appreciated.=IF(NOT(ISNUMBER(FIND(quot;-quot;,A1))),1,MID(A1,FIND(quot;-quot;,A1) 1,255)-LEFT(A1,FIND(quot;-
quot;,A1)-1) 1)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;brendan_docquot; gt; wrote in message ups.com...
gt; I'm trying to find an Excel formula which will give me the total number
gt; of entries in a range.
gt;
gt;
gt; 1-4 should provide 4
gt; 2 should provide 1
gt; 345 should provide 1
gt; 1-17 should provide 17
gt; 13-23 should provide 11
gt;
gt; So the actual value of the number is not important but I need to return
gt; the number in the range of values.
gt; Any help much appreciated.
gt;