| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
countif a number even if counted more than once in the same cell???
if anyone could i would greatly appreciate it,
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 - |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 - |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif if counted results are based on formula | Excel Worksheet Functions | |||
| countif with cell ref vs fixed number... | Excel Discussion (Misc queries) | |||
| Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
| How do I COUNTIF from previously counted data? | Excel Worksheet Functions | |||
| Merging Cells but have each cell counted in the range of merged c. | Excel Worksheet Functions | |||
Linear Mode
