LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
LLM
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup on large text in cells Gus Excel Worksheet Functions 2 February 23rd 06 06:55 PM
Delete text in cells but keep formula YanYan Excel Worksheet Functions 4 December 1st 05 01:08 PM
Text shown up in other cells everytime a text is entered in 1 cell bioyyy Excel Discussion (Misc queries) 1 August 26th 05 05:26 PM
Format text across cells peterlsutton New Users to Excel 3 February 21st 05 07:54 PM
how do i add the same text after current text in multiple cells Sue Excel Discussion (Misc queries) 3 January 13th 05 09:28 PM


All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"