+ Reply to Thread
Results 1 to 3 of 3

if with sumproduct or countif or Something else???

  1. #1
    Registered User
    Join Date
    04-12-2012
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    2

    if with sumproduct or countif or Something else???

    I have orders that get sent out daily and are supposed to be received signed within 30 days. Our system tracks the dates they were sent and received. I need to calculate how many are received within 30 days, over 30 days and outstanding. Also along with the count of each, looking to get the percentages, but I can do that after the counts.

    So for the total sent for February, I am using =SUMPRODUCT((Detail!K2:K12565>=40940)*(Detail!K2:K12565<40969))
    My received column is O. How do I find out the number of orders sent in February and returned within 30 days? Also may want to find out how many sent out in February and were received before April 1.

  2. #2
    Forum Expert 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: if with sumproduct or countif or Something else???

    Hi

    Your formula, works for me!

    Would you like to upload a sample workbook, to show us, your problem?
    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
    Registered User
    Join Date
    04-12-2012
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: if with sumproduct or countif or Something else???

    That formula only tells me how many I sent. I need to determine how many I received back.

    I was able to determine how many I received back in February and March by using
    =COUNTIFS(Detail!$K:$K,">=40940",Detail!$K:$K,"<40969",Detail!$O:$O,"<41000")

    But I need to change it to the total I received back within 30 days from the date sent.

+ 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