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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum cells IF no text present
The sum function is tailor made for this request.
=sum(a1:a3) -- Kevin Vaughn "LLM" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum cells IF no text present
Use SUM, it ignores text so =SUM(A1:A5) will sum any numeric values in the range A1:A5, e.g. 0.3 but ignore text entries e.g. 0.1U If you have a non-contiguous range then you can use something like =SUM(A1,A3,A5) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=510224 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum cells IF no text present
Thanks! I had been using the basic =A2+A4 format. The SUM works fine.
|
Reply |
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) |