Results 1 to 4 of 4

Sumif value ignore two cell value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-07-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    372

    Sumif value ignore two cell value

    Hi Excel Forum.

    I want sumif value excluding two cells.(A11 and A19)

    Data:

    Part Qty

    A1 6925283 1
    A2 6021309 1
    A3 BS5-24P 1
    A4 AC5R-24 1
    A5 6253081 1
    A6 6921080 1
    A7 6071042 1
    A8 6964076 1
    A9 6215251 1
    A10 6719233 1(Ignore Value)
    A11 100-280 1
    A12 FSG6300 1
    A13 6254606 1
    A14 6253930 1
    A15 1477H 1
    A16 1700000 1
    A17 6243855 1
    A18 108-109 2(Ignore Value)
    A19 6925159 4

    Desired Result:

    Part Desired Results

    G4 AC5R-24 1
    G5 6253081 1
    G6 6921080 1
    G7 6071042 1
    G7 6719233 0(Desired Results)
    G8 6241550 20
    G9 6246857 15
    G10 6941084 1
    G11 108-109 0(Desired Results)

    Sum 40.

    File attached.please help me.
    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] Ignore #N/A in sumif and average if
    By justinr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2015, 04:08 PM
  2. [SOLVED] Using SUMIF and IFERROR to sum all $ values and ignore NUM
    By JC_LA_1979 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-29-2014, 06:19 PM
  3. [SOLVED] Sumif two colomns to ignore if a value is present
    By nickmax1 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 01-21-2013, 10:45 AM
  4. Ignore NA in sumif
    By amartino44 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-04-2013, 08:40 PM
  5. Ignore blanks using =SUMIF/COUNTIF
    By Casper9T9 in forum Excel General
    Replies: 10
    Last Post: 06-05-2009, 05:26 PM
  6. how do i create a SUMIF to ignore cells hidden with autofilter
    By JONNY981 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-06-2009, 10:14 AM
  7. How do you ignore hidden rows in a SUMIF() function?
    By Gerry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-21-2005, 09:05 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