• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

YTD Sum of Cat wise"Qty TGT" and "Value TGT" for FY 19-20

Naresh Yadav

Active Member
Respected All,

I have a data in column with heading name "cat", "Qty TGT" and "Value TGT" for FY 19-20
and I want the category wise YTD Sum of "Qty TGT" and Value "TGT"
kinldy find the attached file and expected result for your reference


Expected Result
YTD Apr-19 to June-19
CatYTD Qty TGTYTD ValueTGT
CJ20123492
CP38451491
CV940904
CZ00
DATA
TTL262731072120421219138568221297842020417218201326303103493938583239297444513256962926474028300172
Apr-19Apr-19May-19May-19Jun-19Jun-19Jul-19Jul-19Aug-19Aug-19Sep-19Sep-19Oct-19Oct-19Nov-19Nov-19Dec-19Dec-19Jan-20Jan-20Feb-20Feb-20Mar-20Mar-20
CATQty TGTVAL TGTQty TGTVAL TGTQty TGTVAL TGTQty TGTVAL TGTQty TGTVAL TGTQty TGTVAL TGTQty TGTVAL TGTQty TGTVAL TGTQty TGTVAL TGTQty TGTVAL TGTQty TGTVAL TGTQty TGTVAL TGT
CJ53676574738573934211507675357694267878576501510374513714641361126741378534748
CP17219770111445139872088690821416840314174539202427992227073321207572302426451820530621257368
CV3165723123143120173993400002990031135451840882192441805628055
CZ000000000000000000000000

regards
Naresh
 

Attachments

Naresh Yadav

Active Member
Dear Sir,

Thanks for your support and Guidance..

I m getting the expected result based on your given formula only if the "cat" name is unique..

I would urge you to please look my sheet again and help me to come out
sorry for not mentioning my criteria in last mail

Regards
Naresh
 

Attachments

vletm

Excel Ninja
Naresh Yadav
Would some 'urge'-word would mean next week or what?
Your expected results keep same no matter of Your minor change ... so?
My each cat has unique name.
What would You mean about 'sorry for not mentioning my criteria in last mail'? ... You didn't think before press [ Post reply ] or what?
 
Top