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

[Naresh Yadav]

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
Cat	YTD Qty TGT	YTD ValueTGT
CJ	20	123492
CP	38	451491
CV	9	40904
CZ	0	0
						DATA
TTL	26	273107	21	204212	19	138568	22	129784	20	204172	18	201326	30	310349	39	385832	39	297444	51	325696	29	264740	28	300172
	Apr-19	Apr-19	May-19	May-19	Jun-19	Jun-19	Jul-19	Jul-19	Aug-19	Aug-19	Sep-19	Sep-19	Oct-19	Oct-19	Nov-19	Nov-19	Dec-19	Dec-19	Jan-20	Jan-20	Feb-20	Feb-20	Mar-20	Mar-20
CAT	Qty TGT	VAL TGT	Qty TGT	VAL TGT	Qty TGT	VAL TGT	Qty TGT	VAL TGT	Qty TGT	VAL TGT	Qty TGT	VAL TGT	Qty TGT	VAL TGT	Qty TGT	VAL TGT	Qty TGT	VAL TGT	Qty TGT	VAL TGT	Qty TGT	VAL TGT	Qty TGT	VAL TGT
CJ	5	36765	7	47385	7	39342	11	50767	5	35769	4	26787	8	57650	15	103745	13	71464	13	61126	7	41378	5	34748
CP	17	219770	11	144513	9	87208	8	69082	14	168403	14	174539	20	242799	22	270733	21	207572	30	242645	18	205306	21	257368
CV	3	16572	3	12314	3	12017	3	9934	0	0	0	0	2	9900	3	11354	5	18408	8	21924	4	18056	2	8055
CZ	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

regards
Naresh

 

[vletm]

Naresh Yadav
1) row 10 'dates' should modify dates!
2) somewhere should be 'from & to' -dates
3) Check 'blue range' ... You can continue from this

 

[Naresh Yadav]

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

 

[vletm]

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?