Thread: Ignore text but not numerics on SUM() function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
squenson via OfficeKB.com squenson via OfficeKB.com is offline
external usenet poster
  
Posts: 78
Default Ignore text but not numerics on SUM() function
A solution that is far from perfect is to remove the K or KB from the text.
So, in a separate column, type the formula (this example supposed that the
1024__ in cell B6, adapt to your needs):
=IF(ISNUMBER(B6), B6, VALUE(SUBSTITUTE(SUBSTITUTE(B6, "KB", ""), "K", "")))

It will not trap other characters though.

Then, you simply make the sum of this column.

Stephane.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200708/1

Reply With QuoteReply With Quote