Thread
:
countif a number even if counted more than once in the same cell???
View Single Post
#
4
Posted to microsoft.public.excel.programming
Sandy Mann
external usenet poster
Posts: 2,345
countif a number even if counted more than once in the same cell??
Try:
=SUM(LEN(A1:E1))-SUM(LEN(SUBSTITUTE(A1:E1,3,"")))
which is an array formula to be entered with Ctrl + Shift + Enter not just
enter.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
wrote in message
...
ok here is what the excel file should look like
3 3 33 3 333 = should equal to 8 3's no matter if there is three
3's in a single cell
hope that helps
On Apr 4, 12:46 pm, Michael wrote:
Write a sample of what the cells have and what do you expect to obtain.
Your questions should be consise but not always so short.
--
If this posting was helpful, please click on the Yes button.
Regards,
Michael Arch.
" wrote:
if anyone could i would greatly appreciate it,- Hide quoted text -
- Show quoted text -
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann