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

if anyone could i would greatly appreciate it,

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

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,

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

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 -

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 -

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

that helped. thnx so much for ur help


On Apr 4, 2:04*pm, "Sandy Mann" wrote:
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 -- Hide quoted text -

- Show quoted text -

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

Glad that it helped. Thanks for the feedback

--

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


Replace @mailinator.com with @tiscali.co.uk


wrote in message
...
that helped. thnx so much for ur help


On Apr 4, 2:04 pm, "Sandy Mann" wrote:
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 -- Hide quoted text -

- Show quoted text -