+ Reply to Thread
Results 1 to 4 of 4

Countif/Sum Product

  1. #1
    Registered User
    Join Date
    08-06-2012
    Location
    Quincy,IL
    MS-Off Ver
    Excel 2003
    Posts
    84

    Countif/Sum Product

    Hi...I guess im not really sure what my question is so im going to throw out my information and hopefully some one can help solve my problem!

    On my attached sheet you will see that my data is laid out pretty basically. At the end of each section (this is just one section there are 5 more) there is the results. In the OOS column her i need it to asses how many X's there are and times it by 2. (Simple got that nailed) The the next column here i need a sum product formula which takes the number in the cell and multiplies it by the number in the header row above it. I get the sumproduct but when there are X's in that row it doesnt read them and my results dont come up correctly which affects my third column which is a combination if statement that adds time weight based on the date of the entry.

    So what im needed i think is a solution (I am open to changing/adding any and all of my formulas) to my X situation. Im not really sure where to go from here. Ive tried a bunch of different tricks and back road ideas but nothing seems to be working.

    Thanks!


    http://www.ozgrid.com/forum/showthre...842#post670842


    EXAMPLE DATA.xlsx

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Countif/Sum Product

    In S8(for example) which is the expected result and why?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Countif/Sum Product

    In cell S6, try this:

    Please Login or Register  to view this content.
    copy/autofill down.

  4. #4
    Registered User
    Join Date
    08-06-2012
    Location
    Quincy,IL
    MS-Off Ver
    Excel 2003
    Posts
    84

    Re: Countif/Sum Product

    ConneXionLost works PERFECTLY! Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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