+ Reply to Thread
Results 1 to 5 of 5

Sum column with text

  1. #1
    Registered User
    Join Date
    02-11-2019
    Location
    Florida, USA
    MS-Off Ver
    365
    Posts
    6

    Sum column with text

    I have a column where some cells have numbers and some have text, specifically N/A. I just want to sum only the numbers on that column. I think this should be pretty easy. But I have tried different formulas and none of them seems to work. Any help will be highly appreciated.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Sum column with text

    If your numbers are in A1 to A15 then enter this formula using Ctrl Shift Enter

    =SUM(IF(ISNUMBER(A1:A15),A1:A15,0))
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,776

    Re: Sum column with text

    =aggregate(9,6,a1:a15)

  4. #4
    Registered User
    Join Date
    02-11-2019
    Location
    Florida, USA
    MS-Off Ver
    365
    Posts
    6

    Re: Sum column with text

    That worked! Thank you!

  5. #5
    Valued Forum Contributor
    Join Date
    08-03-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, Office 365
    Posts
    467

    Re: Sum column with text

    Hi

    In my Excel2010, using =SUM(A1:A15) ignores all text values in the range and just gives the numeric total.
    It's only if there are error values within that range (like #N/A) that gives an error for the SUM (i.e text value of N/A is ignored, but #N/A is not)

    zeddy

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA: Look for partial text in Column A from Column B and paste text offset Column A
    By coryspeth in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-07-2018, 05:53 AM
  2. Merged Column of text to column of single cell text values
    By wayneajt1990 in forum Excel General
    Replies: 2
    Last Post: 03-07-2018, 07:30 AM
  3. [SOLVED] Macro to Copy and Paste Specific Text in Column A on the last line with Text in Column B?
    By D2S in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2017, 04:08 PM
  4. [SOLVED] VBA Macro to find text string in one column and replace specific text in another column if
    By bmahfood in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2017, 11:15 AM
  5. Filter column by text, then export column to new workbook, replace searched text with new.
    By Headhunter234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2015, 07:48 AM
  6. Trying to write amacro to compare text in column A to garbage text in column B
    By Big Dawg Dad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2013, 03:31 PM

Tags for this Thread

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