+ Reply to Thread
Results 1 to 10 of 10

YTD Calculation Help Required

  1. #1
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    YTD Calculation Help Required

    Dear Experts,

    Please help on ytd calculation mentioned in the attached file.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: YTD Calculation Help Required

    Please show the expected result also for giving exact solution

  3. #3
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: YTD Calculation Help Required

    Dear,

    If I change month in the cel (K3,L3,M3)(Below YTD) then for different products mentioned in(K3,L3,M3 x,y,z)) it will provide ydt figure of sales in cels (K5,L5,M5 & K6,L6,M6).

    I used this formula SUMIF(B3:J3,K3,B5:INDEX(B5:J5,MATCH(K2,B2:J2,0))) but its not working properly.

    pls help

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: YTD Calculation Help Required

    In K5 Cell

    =SUMIFS($B5:$J5,$B$2:$J$2,K$2,$B$3:$J$3,K$3)

    Drag it down and right...

  5. #5
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: YTD Calculation Help Required

    Dear,

    Thanks for your support.

    But it still not providing the appropriate result if I put May-13 or Jun-13(below YTD..year to date) then it should provide sum for the different products(X,Y,Z).
    But it is providing figure only for that month not the sum for each product till the period mentioned in below ytd.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: YTD Calculation Help Required

    Again show the expected result.

  7. #7
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: YTD Calculation Help Required

    Till jun-13 for x it will show 363 in cel k5 if I change period in cel k2

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: YTD Calculation Help Required

    Quote Originally Posted by caashishddm View Post
    Till jun-13 for x it will show 363 in cel k5 if I change period in cel k2
    In K5 Cell

    =SUMIFS($B5:$J5,$B$2:$J$2,"<="&K$2,$B$3:$J$3,K$3)

    Drag it down and right...

  9. #9
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: YTD Calculation Help Required

    Thanks Dear for helping me.

    Working absolutely fine.

  10. #10
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: YTD Calculation Help Required

    could you explain me reason of using"<=" this

  11. #11
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: YTD Calculation Help Required

    Quote Originally Posted by caashishddm View Post
    could you explain me reason of using"<=" this
    < means Less Than
    = means Equal To
    <= means Less Than Or Equal To

    So I just used it to sum all the data which is less than or equal to the given date

+ 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. Blank cell if no calculation required
    By unsnz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-12-2013, 08:57 PM
  2. Postcode distance Calculation (urgent help required)
    By stevennicholls in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-23-2013, 06:58 AM
  3. Help required to work out calculation... Please...
    By Snowmonster in forum Excel General
    Replies: 2
    Last Post: 10-02-2012, 05:11 AM
  4. Replies: 12
    Last Post: 07-25-2007, 11:34 AM
  5. [SOLVED] Help required to automate calculation
    By Tom in forum Excel General
    Replies: 1
    Last Post: 02-02-2005, 10: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