Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum cells IF no text present
Hello,
I am a novice excel user and I am trying to sum cells, some of which have numbers and text, others that have only numbers. I have to add, for example: 0.2U, 0.3, 0.1U. Or 0.4U, 0.5U. I need to add only the cells that do not contain text. The first example should return a sum of 0.3, the second should return 0. Any suggestions? LLM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup on large text in cells | Excel Worksheet Functions | |||
Delete text in cells but keep formula | Excel Worksheet Functions | |||
Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
Format text across cells | New Users to Excel | |||
how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) |