Results 1 to 3 of 3

SUMIF discontinuous cells

Threaded View

  1. #1
    Registered User
    Join Date
    03-01-2019
    Location
    Nebraska, USA
    MS-Off Ver
    2010
    Posts
    1

    Question SUMIF discontinuous cells

    Attachment 613688

    I want W6 formula to return SUM of MTL QTY values IF row 2 denotes "Notice to Proceed" in the paired columns........my current formula of =SUMIF([E2, G2, I2, K2, M2, O2, Q2, S2, U2], "Notice to Proceed", [E6,G6,I6,K6,M6,O6,Q6,S6,U6]) is not working. I tried both merging and unmerging my row 2 cells. I assumed the problem was discontinuous ranges for criteria and sum? Please help!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count numeric cells in discontinuous range
    By JayUSA in forum Excel General
    Replies: 3
    Last Post: 03-16-2018, 10:38 PM
  2. [SOLVED] Excel 2003: Making a Drop Down List from a Range of Discontinuous Cells
    By helpmeinexcel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-26-2013, 02:16 PM
  3. SUMIF in discontinuous range with possible #N/As
    By lesoies in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-14-2012, 10:03 AM
  4. [SOLVED] Allow pasting as a value to several discontinuous cells at once.
    By Harveywater in forum Excel General
    Replies: 1
    Last Post: 07-07-2006, 03:55 AM
  5. [SOLVED] Can an array be made of discontinuous cells of the same row?
    By vanillawand in forum Excel General
    Replies: 0
    Last Post: 02-03-2006, 07:25 AM
  6. [SOLVED] COUNTIF:series of discontinuous cells
    By nsharpe in forum Excel General
    Replies: 7
    Last Post: 09-07-2005, 06:05 PM
  7. [SOLVED] Worksheet_Change with discontinuous cells
    By JKG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2005, 03:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1