+ Reply to Thread
Results 1 to 4 of 4

How to Apply Condition week No Against Date

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

    Exclamation How to Apply Condition week No Against Date

    Hi,

    Query-1

    i have created the week calendar for the month.

    Week No Date From To
    Week01 02.03.2015 05.03.2015
    Week02 06.03.2015 12.03.2015
    Week03 13.03.2015 19.03.2015
    Week04 20.03.2015 26.03.2015
    Week05 27.03.2015 31.03.2015

    Invoice Date Dispatch Date Week

    02.03.2015 02.03.2015 Week01

    03.03.2015 06.03.2015 0

    06.03.2015 07.03.2015 Week02

    07.03.2015 13.03.2015 0

    if dispatch covered same week value return the same.

    in case dispatch covered next week value return 0.

    Query-02

    How to do sumif Row to column

    File attached herewith.

    pl help me.
    Attached Files Attached Files
    Last edited by zbor; 05-07-2015 at 04:01 AM. Reason: title editer per OP request

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Condition

    Hi,

    I have updated the formulae in the attached file.

    "Query-01" in K2:

    =SUMIFS($C$2:$C$50,$B$2:$B$50,">="&I2,$B$2:$B$50,"<="&J2)

    "Query-02" in I2

    =SUMIFS($C$2:$C$27,$B$2:$B$27,">="&G2,$B$2:$B$27,"<="&H2)
    Attached Files Attached Files

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

    Re: Condition

    Query 1

    i want formula column E.

    if dispatch covered same week value return the same.

    in case dispatch covered next week value return 0.

    file attached pl help me.


    Query 2 solved.
    Attached Files Attached Files

  4. #4
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Condition

    Copy the following formula in F2 and drag down:

    =IF(LOOKUP(B2,$I$2:$J$6,$H$2:$H$6)=LOOKUP(D2,$I$2:$J$6,$H$2:$H$6),LOOKUP(B2,$I$2:$J$6,$H$2:$H$6),0)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Condition formatting of multiple condition formatted cells
    By merrin84 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-22-2015, 05:08 PM
  2. [SOLVED] IF the condition of gender is met AND the condition of age is met subtract this number
    By arsenalmom in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-16-2014, 11:16 PM
  3. [SOLVED] Help for if condition formula result only either hit or miss from mulitple condition
    By breadwinner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2013, 07:29 AM
  4. Replies: 6
    Last Post: 05-06-2010, 10:06 PM
  5. multi condition format? lookup and date condition valid for.
    By D_Rennie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-13-2009, 11:37 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