Hi All, I have got two summarized result in the attached sheet I want to add the count column in to one. the First is the result of one summarize and the next one is the second. I want to add up the count Summaize 1 Summarize 2 yearmonthcount yearmonthcount2016142 20161292016240 20162272016332 20163252016427 20164362016535 20165282016638 20166162016736 20167422016840 20168392016923 201693320161035 2016102220161150 2016112920161240 201612232017136 20171232017237 20172162017346 20173232017444 20174312017553 20175212017642 20176212017740 20177352017830 20178302017928 201792320171037 2017103420171142 2017113120171221 201712252018119 20181242018238 20182212018340 20183232018426 20184292018543 20185242018631 20186202018730 20187342018831 20188282018926 201892220181041 2018103720181133 2018112320181239 201812192019131 20191342019228 20192152019325 20193202019425 20194292019531 20195402019627 20196212019727 20197312019831 20198352019925 201993020191041 2019102820191119 2019112020191228 201912152020133 20201162020223 20202172020327 20203112020419 2020410202051 Please help. Regards rohini

adding up the result from summrize

Hi All,

I have got two summarized result in the attached sheet I want to add the count column in to one. the First is the result of one summarize and the next one is the second. I want to add up the count

Summaize 1			Summarize 2
year	month	count		year	month	count
2016	1	42		2016	1	29
2016	2	40		2016	2	27
2016	3	32		2016	3	25
2016	4	27		2016	4	36
2016	5	35		2016	5	28
2016	6	38		2016	6	16
2016	7	36		2016	7	42
2016	8	40		2016	8	39
2016	9	23		2016	9	33
2016	10	35		2016	10	22
2016	11	50		2016	11	29
2016	12	40		2016	12	23
2017	1	36		2017	1	23
2017	2	37		2017	2	16
2017	3	46		2017	3	23
2017	4	44		2017	4	31
2017	5	53		2017	5	21
2017	6	42		2017	6	21
2017	7	40		2017	7	35
2017	8	30		2017	8	30
2017	9	28		2017	9	23
2017	10	37		2017	10	34
2017	11	42		2017	11	31
2017	12	21		2017	12	25
2018	1	19		2018	1	24
2018	2	38		2018	2	21
2018	3	40		2018	3	23
2018	4	26		2018	4	29
2018	5	43		2018	5	24
2018	6	31		2018	6	20
2018	7	30		2018	7	34
2018	8	31		2018	8	28
2018	9	26		2018	9	22
2018	10	41		2018	10	37
2018	11	33		2018	11	23
2018	12	39		2018	12	19
2019	1	31		2019	1	34
2019	2	28		2019	2	15
2019	3	25		2019	3	20
2019	4	25		2019	4	29
2019	5	31		2019	5	40
2019	6	27		2019	6	21
2019	7	27		2019	7	31
2019	8	31		2019	8	35
2019	9	25		2019	9	30
2019	10	41		2019	10	28
2019	11	19		2019	11	20
2019	12	28		2019	12	15
2020	1	33		2020	1	16
2020	2	23		2020	2	17
2020	3	27		2020	3	11
2020	4	19		2020	4	10
2020	5	1