Results 1 to 3 of 3

Still having trouble using sumproduct to add qty's

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-18-2012
    Location
    Chicopee, Ma
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    199

    Still having trouble using sumproduct to add qty's

    I'm using sumproduct to add up all the quantities of jobs in house.
    The formula I'm using is in cell O3.
    not sure what I'm doing wrong.
    I'm asking the formula to look at column I and look for anything equal to 1
    Then I'm asking it to look for cells that contain "Qty"
    Then I'm asking it to sum all the jobs that are in house.
    It keeps giving me a Value error.

    Please help.

    Thanks 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] Trouble with the use of Countif and Sumproduct
    By alex_a in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2012, 11:46 AM
  2. Sumproduct trouble
    By rimisar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2009, 11:00 AM
  3. Trouble with SUMPRODUCT
    By edwardpestian in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-05-2006, 03:10 AM
  4. [SOLVED] Trouble with SUMPRODUCT
    By Craig in forum Excel General
    Replies: 5
    Last Post: 04-07-2005, 09:06 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