| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to add numbers that include text.
Ex. In Column B there are 30 cells. I need to know the total of the numbers
with xs. I do not need to know the total of cells that have the text xs in it. Cell 1 has 2 xs (xsmall) Cell 2 has 3 s (small) Cell 3 has 2 s Cell 4 has 3 xs Cell 5 has 1 xs I need to know the total of xs is 6. I keep getting 3 or zero. I need to know what formula to use. Then I can use the same formula to get the total of s. Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort Room Numbers that include Alphabetes | Excel Worksheet Functions | |||
| How do I include filtered out numbers in a SUBTOTAL? | Excel Worksheet Functions | |||
| adding cells which include numbers and text | Excel Discussion (Misc queries) | |||
| adding cells which include numbers and text | Excel Discussion (Misc queries) | |||
| Sum numbers that include #N/A | Excel Worksheet Functions | |||
Threaded Mode
