countif a number even if counted more than once in the same cell???

[jzamilpa3]

if anyone could i would greatly appreciate it,

 

[Michael]

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.

 

[jzamilpa3]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


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

 

[jzamilpa3]

that helped. thnx so much for ur help

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


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






- Show quoted text -

 

[Sandy Mann]

Glad that it helped. Thanks for the feedback

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


that helped. thnx so much for ur help