Results 1 to 7 of 7

Excel to Ignore Text and Sum Values

Threaded View

  1. #4
    Registered User
    Join Date
    05-30-2017
    Location
    Bay Area, CA
    MS-Off Ver
    2016
    Posts
    5

    Re: Excel to Ignore Text and Sum Values

    The array formula helped me parse everything which is great but now I thought I'd be able to perform the auto sum. It doesn't add correctly though.

    Now my columns look like this

    COLUMN A                 COLUMN B               COLUMN C
    10.172.161.0/24	           20.0% (8/40)	              (8/40)
    10.172.162.0/24	            5.0% (10/200)	      (10/200)
    10.172.163.0/24	            0.0% (0/0)	              (0/0)
    10.172.164.0/23	            58.0% (259/446)         (259/446)
    Last edited by nfordhk; 05-30-2017 at 07:51 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Ignore Text in a Cell and Sum Only the Values of the First 3 Non Zero Numbers
    By akurei in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 05-31-2017, 04:27 PM
  2. [SOLVED] I want a formula to ignore text values in cell references
    By Russellrupert in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-05-2016, 03:53 PM
  3. Combine 2 Excel columns into 1 - use number and ignore text
    By emmafutter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2016, 07:35 AM
  4. [SOLVED] Calculating turn around time for taskers and ignore text values
    By AndreBlush in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2013, 02:44 PM
  5. How can excel ignore certain text when it searches for text?
    By jonathynblythe in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-18-2011, 08:33 PM
  6. [SOLVED] Can I ignore numbers and sort only text in an Excel column?
    By justaMom in forum Excel General
    Replies: 5
    Last Post: 04-26-2006, 09:10 PM
  7. Ignore Text, function only for numerical values
    By Daniel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1