Results 1 to 4 of 4

Sumifs issue with formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,225

    Sumifs issue with formula

    Hi

    I have a pretty simple formula but it seems to be double counting or not sure what's really doing

    Formula in cell F2 "Summary" sheet

    =SUMIFS(Data!$L:$L,Data!$Z:$Z,Summary!G2)
    for the first item labelled "<N/A>", it's showing 57K when it should be ~20K.

    Can someone pls help me understand why that is? providing sample workbook.

    FYI, the total in the "data" sheet is 66K, and when i total my entries in summary sheet, it shows 103K. The issue is with <N/A> label. I tried to call it "Blank" and other, but no luck.

    thx in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumifs issue
    By wright5fam in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2021, 03:02 AM
  2. SumIfs Issue
    By lhchap18 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2021, 03:49 AM
  3. [SOLVED] SUMIFS Formula Issue
    By SamDz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2019, 08:26 AM
  4. [SOLVED] SUMIFS formula to replace SUMPRODUCT because of ressource issue
    By lillumultipass in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 12-14-2017, 08:05 AM
  5. Issue With Not Equal To in SUMIFS Formula
    By Comptka in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-06-2015, 02:29 PM
  6. sumifs + offset formula issue
    By jw01 in forum Excel General
    Replies: 6
    Last Post: 02-11-2015, 11:05 AM
  7. SUMIFS Formula Issue
    By keithd203 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-18-2013, 04:15 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