+ 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

    Hi,

    Pls find in attachment.The formula is in BA in SO Sheet.AJ of SO Sheet and 'X' column of DO sheet could not able to remove space by find & replace.
    Attached Files Attached Files

+ 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