+ Reply to Thread
Results 1 to 3 of 3

Unable to Sum Column due to text in a range

  1. 09-07-2016, 03:12 AM #1
    nomi2565
    nomi2565 is offline
    Registered User
    Join Date
    06-24-2016
    Location
    United States
    MS-Off Ver
    2016
    Posts
    5

    Unable to Sum Column due to text in a range

    Unable to Sum Column due to text in a range2016-09-07_000645.png
    Reply With QuoteRegister To Reply
  2. 09-07-2016, 03:26 AM #2
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Unable to Sum Column due to text in a range

    Try

    =AGGREGATE(9,6,sumrange)
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  3. 09-07-2016, 03:29 AM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,411

    Re: Unable to Sum Column due to text in a range

    You should fix the errors generated by your formulae using IFERROR.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unable to text-to-column
    By spearhead in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 12-24-2015, 10:07 AM
  2. Unable to convert data to text to column
    By ruchika137 in forum Excel General
    Replies: 2
    Last Post: 09-30-2015, 11:25 AM
  3. [SOLVED] Data goes to Column A, I use text to column but am unable to use the numbers as it gives..
    By kucke in forum Excel General
    Replies: 43
    Last Post: 05-02-2015, 02:52 AM
  4. How to reference text from a range in one column depending on text in another column.
    By RichPee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2014, 07:21 AM
  5. [SOLVED] Cond. formatting a column/Range, highlight cell in column/range if equal to specific text
    By DFrank231 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2013, 03:35 PM
  6. Unable to Edit Userform, unable to resize, move any objects, unable to right click
    By barteklv in forum Excel General
    Replies: 3
    Last Post: 11-08-2012, 07:25 PM
  7. Unable to set the hidden property of the range class - Column Hiding
    By chobson in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-19-2011, 10:40 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1