+ Reply to Thread
Results 1 to 13 of 13

Displaying wrong result on SUMIFS due to space in left

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2024
    Posts
    1,384

    Re: Displaying wrong result on SUMIFS due to space in left

    Dear Sir,

    The data is exported from a software where it has more than 3000 data.The problem I have been facing is that of spaces in extreme left.It is clear that above mentioned formula I am using and on using trim to each it is creating an error.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Displaying wrong result on SUMIFS due to space in left

    Quote Originally Posted by paradise2sr View Post
    The data is exported from a software where it has more than 3000 data.
    You don't need to post the whole file with 1000's of rows of data.

    Just enough data to demonstrate the problem. 20 rows worth of data is plenty.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. [SOLVED] Code result wrong but formula correct result
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-11-2014, 12:26 PM
  2. Wrong result displaying using IFERROR-INDEX-MATCH-ROW Formula
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-16-2013, 01:03 PM
  3. SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result
    By haldavid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2013, 03:42 PM
  4. only pull from LEFT until a space
    By loner2003 in forum Excel General
    Replies: 4
    Last Post: 02-17-2011, 11:44 AM
  5. Pull left and right until space
    By maxthebear in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-11-2009, 10:40 AM
  6. excel result return wrong calcuation result
    By garyww in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2006, 06:20 AM
  7. space left for future entry = #DIV/0!
    By clooney in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-24-2006, 09:46 AM

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