How to Calculate Date data with Sumif / Sumifs ?

[MohammadAdnan]

Daer Boss,
PFB the table of excell . and please share the result.

Daily Sales	1-Jul-17	2-Jul-17	3-Jul-17	4-Jul-17	5-Jul-17	6-Jul-17	7-Jul-17	8-Jul-17	9-Jul-17	10-Jul-17	11-Jul-17	12-Jul-17	13-Jul-17	14-Jul-17	15-Jul-17	16-Jul-17	17-Jul-17	18-Jul-17	19-Jul-17	20-Jul-17	21-Jul-17	22-Jul-17	23-Jul-17	24-Jul-17	25-Jul-17	26-Jul-17	27-Jul-17	28-Jul-17	29-Jul-17	30-Jul-17	31-Jul-17	1-Aug-17	2-Aug-17	3-Aug-17	4-Aug-17	5-Aug-17	6-Aug-17	7-Aug-17	8-Aug-17	9-Aug-17	10-Aug-17	11-Aug-17	12-Aug-17	13-Aug-17	14-Aug-17	15-Aug-17	16-Aug-17	17-Aug-17	18-Aug-17	19-Aug-17	20-Aug-17	21-Aug-17	22-Aug-17	23-Aug-17	24-Aug-17	25-Aug-17	26-Aug-17	27-Aug-17	28-Aug-17	29-Aug-17	30-Aug-17	31-Aug-17	1-Sep-17	2-Sep-17	3-Sep-17	4-Sep-17	5-Sep-17	6-Sep-17	7-Sep-17	8-Sep-17	9-Sep-17	10-Sep-17	11-Sep-17	12-Sep-17	13-Sep-17	14-Sep-17	15-Sep-17	16-Sep-17	17-Sep-17	18-Sep-17	19-Sep-17	20-Sep-17	21-Sep-17	22-Sep-17	23-Sep-17	24-Sep-17	25-Sep-17	26-Sep-17	27-Sep-17	28-Sep-17	29-Sep-17	30-Sep-17	1-Oct-17	2-Oct-17	3-Oct-17	4-Oct-17	5-Oct-17	6-Oct-17	7-Oct-17	8-Oct-17	9-Oct-17	10-Oct-17	11-Oct-17	12-Oct-17	13-Oct-17	14-Oct-17	15-Oct-17	16-Oct-17	17-Oct-17	18-Oct-17	19-Oct-17	20-Oct-17	21-Oct-17	22-Oct-17	23-Oct-17	24-Oct-17	25-Oct-17	26-Oct-17	27-Oct-17	28-Oct-17	29-Oct-17	30-Oct-17	31-Oct-17	1-Nov-17	2-Nov-17	3-Nov-17	4-Nov-17	5-Nov-17	6-Nov-17	7-Nov-17	8-Nov-17	9-Nov-17	10-Nov-17	11-Nov-17	12-Nov-17	13-Nov-17	14-Nov-17	15-Nov-17	16-Nov-17	17-Nov-17	18-Nov-17	19-Nov-17	20-Nov-17	21-Nov-17	22-Nov-17	23-Nov-17	24-Nov-17	25-Nov-17	26-Nov-17	27-Nov-17	28-Nov-17	29-Nov-17	30-Nov-17	1-Dec-17	2-Dec-17	3-Dec-17	4-Dec-17	5-Dec-17	6-Dec-17	7-Dec-17	8-Dec-17	9-Dec-17	10-Dec-17	11-Dec-17	12-Dec-17	13-Dec-17	14-Dec-17	15-Dec-17	16-Dec-17	17-Dec-17	18-Dec-17	19-Dec-17	20-Dec-17	21-Dec-17	22-Dec-17	23-Dec-17	24-Dec-17	25-Dec-17	26-Dec-17	27-Dec-17	28-Dec-17	29-Dec-17	30-Dec-17	31-Dec-17	1-Jan-18	2-Jan-18	3-Jan-18	4-Jan-18	5-Jan-18	6-Jan-18	7-Jan-18	8-Jan-18	9-Jan-18	10-Jan-18	11-Jan-18	12-Jan-18	13-Jan-18	14-Jan-18	15-Jan-18	16-Jan-18	17-Jan-18	18-Jan-18	19-Jan-18	20-Jan-18	21-Jan-18	22-Jan-18	23-Jan-18	24-Jan-18	25-Jan-18	26-Jan-18	27-Jan-18	28-Jan-18	29-Jan-18	30-Jan-18	31-Jan-18	1-Feb-18	2-Feb-18	3-Feb-18	4-Feb-18	5-Feb-18	6-Feb-18	7-Feb-18	8-Feb-18	9-Feb-18	10-Feb-18	11-Feb-18	12-Feb-18	13-Feb-18	14-Feb-18	15-Feb-18	16-Feb-18	17-Feb-18	18-Feb-18	19-Feb-18	20-Feb-18	21-Feb-18	22-Feb-18	23-Feb-18	24-Feb-18	25-Feb-18	26-Feb-18	27-Feb-18	28-Feb-18	1-Mar-18	2-Mar-18	3-Mar-18	4-Mar-18	5-Mar-18	6-Mar-18	7-Mar-18	8-Mar-18	9-Mar-18	10-Mar-18	11-Mar-18	12-Mar-18	13-Mar-18	14-Mar-18	15-Mar-18	16-Mar-18	17-Mar-18	18-Mar-18	19-Mar-18	20-Mar-18	21-Mar-18	22-Mar-18	23-Mar-18	24-Mar-18	25-Mar-18	26-Mar-18	27-Mar-18	28-Mar-18	29-Mar-18	30-Mar-18	31-Mar-18	1-Apr-18	2-Apr-18	3-Apr-18	4-Apr-18	5-Apr-18	6-Apr-18	7-Apr-18	8-Apr-18	9-Apr-18	10-Apr-18	11-Apr-18	12-Apr-18	13-Apr-18	14-Apr-18	15-Apr-18	16-Apr-18	17-Apr-18	18-Apr-18	19-Apr-18	20-Apr-18	21-Apr-18	22-Apr-18	23-Apr-18	24-Apr-18	25-Apr-18	26-Apr-18	27-Apr-18	28-Apr-18	29-Apr-18	30-Apr-18	1-May-18	2-May-18	3-May-18	4-May-18	5-May-18	6-May-18	7-May-18	8-May-18	9-May-18	10-May-18	11-May-18	12-May-18	13-May-18	14-May-18	15-May-18	16-May-18	17-May-18	18-May-18	19-May-18	20-May-18	21-May-18	22-May-18	23-May-18	24-May-18	25-May-18	26-May-18	27-May-18	28-May-18	29-May-18	30-May-18	31-May-18
Center	Faislabad	2	10	12	68	62	-4	18	-32	140	186	-10	-12	-68	-64	6	30	36	204	186	-12	54	-96	420	558	-30	-36	-204	-192	3	11	13	69	63	-3	19	-31	141	187	-9	-11	-67	-63	7	31	37	205	187	-11	55	-95	421	559	-29	-35	-203	-191	2	10	12	68	62	-4	18	-32	140	186	-10	-12	-68	-64	6	30	36	204	186	-12	54	-96	420	558	-30	-36	-204	-192	3	11	13	69	63	-3	19	-31	141	187	-9	-11	-67	-63	7	31	37	205	187	-11	55	-95	421	559	-29	-35	-203	-191	2	10	12	68	62	-4	18	-32	140	186	-10	-12	-68	-64	6	30	36	204	186	-12	54	-96	420	558	-30	-36	-204	-192	3	11	13	69	63	-3	19	-31	141	187	-9	-11	-67	-63	7	31	37	205	187	-11	55	-95	421	559	-29	-35	-203	-191	2	10	12	68	62	-4	18	-32	140	186	-10	-12	-68	-64	6	30	36	204	186	-12	54	-96	420	558	-30	-36	-204	-192	3	11	13	69	63	-3	19	-31	141	187	-9	-11	-67	-63	7	31	37	205	187	-11	55	-95	421	559	-29	-35	-203	-191	4	100	144	4624	3844	16	324	1024	19600	34596	100	144	4624	4096	36	900	1296	41616	34596	144	2916	9216	176400	311364	900	1296	41616	36864	9	121	169	4761	3969	9	361	961	19881	34969	81	121	4489	3969	49	961	1369	42025	34969	121	3025	9025	177241	312481	841	1225	41209	36481	4	100	144	4624	3844	16	324	1024	19600	34596	100	144	4624	4096	36	900	1296	41616	34596	144	2916	9216	176400	311364	900	1296	41616	36864	9	121	169	4761	3969	9	361	961	19881	34969	81	121	4489	3969	49	961	1369	42025	34969	121	3025	9025	177241	312481	841	1225	41209
Center	Gujranwala	2	10	12	68	62	-4	18	-32	140	186	-10	-12	-68	-64	6	30	36	204	186	-12	54	-96	420	558	-30	-36	-204	-192	3	11	13	69	63	-3	19	-31	141	187	-9	-11	-67	-63	7	31	37	205	187	-11	55	-95	421	559	-29	-35	-203	-191	2	10	12	68	62	-4	18	-32	140	186	-10	-12	-68	-64	6	30	36	204	186	-12	54	-96	420	558	-30	-36	-204	-192	3	11	13	69	63	-3	19	-31	141	187	-9	-11	-67	-63	7	31	37	205	187	-11	55	-95	421	559	-29	-35	-203	-191	2	10	12	68	62	-4	18	-32	140	186	-10	-12	-68	-64	6	30	36	204	186	-12	54	-96	420	558	-30	-36	-204	-192	3	11	13	69	63	-3	19	-31	141	187	-9	-11	-67	-63	7	31	37	205	187	-11	55	-95	421	559	-29	-35	-203	-191	2	10	12	68	62	-4	18	-32	140	186	-10	-12	-68	-64	6	30	36	204	186	-12	54	-96	420	558	-30	-36	-204	-192	3	11	13	69	63	-3	19	-31	141	187	-9	-11	-67	-63	7	31	37	205	187	-11	55	-95	421	559	-29	-35	-203	-191	4	100	144	4624	3844	16	324	1024	19600	34596	100	144	4624	4096	36	900	1296	41616	34596	144	2916	9216	176400	311364	900	1296	41616	36864	9	121	169	4761	3969	9	361	961	19881	34969	81	121	4489	3969	49	961	1369	42025	34969	121	3025	9025	177241	312481	841	1225	41209	36481	4	100	144	4624	3844	16	324	1024	19600	34596	100	144	4624	4096	36	900	1296	41616	34596	144	2916	9216	176400	311364	900	1296	41616	36864	9	121	169	4761	3969	9	361	961	19881	34969	81	121	4489	3969	49	961	1369	42025	34969	121	3025	9025	177241	312481	841	1225	41209
Center	Lahore	3	15	21	153	141	-6	24	-90	315	423	-15	-21	-153	-144	9	45	63	459	423	-18	72	-270	945	1269	-45	-63	-459	-432	4	16	22	154	142	-5	25	-89	316	424	-14	-20	-152	-143	10	46	64	460	424	-17	73	-269	946	1270	-44	-62	-458	-431	3	15	21	153	141	-6	24	-90	315	423	-15	-21	-153	-144	9	45	63	459	423	-18	72	-270	945	1269	-45	-63	-459	-432	4	16	22	154	142	-5	25	-89	316	424	-14	-20	-152	-143	10	46	64	460	424	-17	73	-269	946	1270	-44	-62	-458	-431	3	15	21	153	141	-6	24	-90	315	423	-15	-21	-153	-144	9	45	63	459	423	-18	72	-270	945	1269	-45	-63	-459	-432	4	16	22	154	142	-5	25	-89	316	424	-14	-20	-152	-143	10	46	64	460	424	-17	73	-269	946	1270	-44	-62	-458	-431	3	15	21	153	141	-6	24	-90	315	423	-15	-21	-153	-144	9	45	63	459	423	-18	72	-270	945	1269	-45	-63	-459	-432	4	16	22	154	142	-5	25	-89	316	424	-14	-20	-152	-143	10	46	64	460	424	-17	73	-269	946	1270	-44	-62	-458	-431	9	225	441	23409	19881	36	576	8100	99225	178929	225	441	23409	20736	81	2025	3969	210681	178929	324	5184	72900	893025	1610361	2025	3969	210681	186624	16	256	484	23716	20164	25	625	7921	99856	179776	196	400	23104	20449	100	2116	4096	211600	179776	289	5329	72361	894916	1612900	1936	3844	209764	185761	9	225	441	23409	19881	36	576	8100	99225	178929	225	441	23409	20736	81	2025	3969	210681	178929	324	5184	72900	893025	1610361	2025	3969	210681	186624	16	256	484	23716	20164	25	625	7921	99856	179776	196	400	23104	20449	100	2116	4096	211600	179776	289	5329	72361	894916	1612900	1936	3844	209764
Center	Multan	4	20	32	272	252	-8	28	-176	560	756	-20	-32	-272	-256	12	60	96	816	756	-24	84	-528	1680	2268	-60	-96	-816	-768	5	21	33	273	253	-7	29	-175	561	757	-19	-31	-271	-255	13	61	97	817	757	-23	85	-527	1681	2269	-59	-95	-815	-767	4	20	32	272	252	-8	28	-176	560	756	-20	-32	-272	-256	12	60	96	816	756	-24	84	-528	1680	2268	-60	-96	-816	-768	5	21	33	273	253	-7	29	-175	561	757	-19	-31	-271	-255	13	61	97	817	757	-23	85	-527	1681	2269	-59	-95	-815	-767	4	20	32	272	252	-8	28	-176	560	756	-20	-32	-272	-256	12	60	96	816	756	-24	84	-528	1680	2268	-60	-96	-816	-768	5	21	33	273	253	-7	29	-175	561	757	-19	-31	-271	-255	13	61	97	817	757	-23	85	-527	1681	2269	-59	-95	-815	-767	4	20	32	272	252	-8	28	-176	560	756	-20	-32	-272	-256	12	60	96	816	756	-24	84	-528	1680	2268	-60	-96	-816	-768	5	21	33	273	253	-7	29	-175	561	757	-19	-31	-271	-255	13	61	97	817	757	-23	85	-527	1681	2269	-59	-95	-815	-767	16	400	1024	73984	63504	64	784	30976	313600	571536	400	1024	73984	65536	144	3600	9216	665856	571536	576	7056	278784	2822400	5143824	3600	9216	665856	589824	25	441	1089	74529	64009	49	841	30625	314721	573049	361	961	73441	65025	169	3721	9409	667489	573049	529	7225	277729	2825761	5148361	3481	9025	664225	588289	16	400	1024	73984	63504	64	784	30976	313600	571536	400	1024	73984	65536	144	3600	9216	665856	571536	576	7056	278784	2822400	5143824	3600	9216	665856	589824	25	441	1089	74529	64009	49	841	30625	314721	573049	361	961	73441	65025	169	3721	9409	667489	573049	529	7225	277729	2825761	5148361	3481	9025	664225
North	Islamabad	56	280	3360	53312	50120	-112	-2520	-43232	109760	150360	-280	-3360	-53312	-50176	168	840	10080	159936	150360	-336	-7560	-129696	329280	451080	-840	-10080	-159936	-150528	57	281	3361	53313	50121	-111	-2519	-43231	109761	150361	-279	-3359	-53311	-50175	169	841	10081	159937	150361	-335	-7559	-129695	329281	451081	-839	-10079	-159935	-150527	56	280	3360	53312	50120	-112	-2520	-43232	109760	150360	-280	-3360	-53312	-50176	168	840	10080	159936	150360	-336	-7560	-129696	329280	451080	-840	-10080	-159936	-150528	57	281	3361	53313	50121	-111	-2519	-43231	109761	150361	-279	-3359	-53311	-50175	169	841	10081	159937	150361	-335	-7559	-129695	329281	451081	-839	-10079	-159935	-150527	56	280	3360	53312	50120	-112	-2520	-43232	109760	150360	-280	-3360	-53312	-50176	168	840	10080	159936	150360	-336	-7560	-129696	329280	451080	-840	-10080	-159936	-150528	57	281	3361	53313	50121	-111	-2519	-43231	109761	150361	-279	-3359	-53311	-50175	169	841	10081	159937	150361	-335	-7559	-129695	329281	451081	-839	-10079	-159935	-150527	56	280	3360	53312	50120	-112	-2520	-43232	109760	150360	-280	-3360	-53312	-50176	168	840	10080	159936	150360	-336	-7560	-129696	329280	451080	-840	-10080	-159936	-150528	57	281	3361	53313	50121	-111	-2519	-43231	109761	150361	-279	-3359	-53311	-50175	169	841	10081	159937	150361	-335	-7559	-129695	329281	451081	-839	-10079	-159935	-150527	3136	78400	11289600	2842169344	2512014400	12544	6350400	1869005824	12047257600	22608129600	78400	11289600	2842169344	2517630976	28224	705600	101606400	25579524096	22608129600	112896	57153600	16821052416	1.08425E+11	2.03473E+11	705600	101606400	25579524096	22658678784	3249	78961	11296321	2842275969	2512114641	12321	6345361	1868919361	12047477121	22608430321	77841	11282881	2842062721	2517530625	28561	707281	101626561	25579843969	22608430321	112225	57138481	16820793025	1.08426E+11	2.03474E+11	703921	101586241	25579204225	22658377729	3136	78400	11289600	2842169344	2512014400	12544	6350400	1869005824	12047257600	22608129600	78400	11289600	2842169344	2517630976	28224	705600	101606400	25579524096	22608129600	112896	57153600	16821052416	1.08425E+11	2.03473E+11	705600	101606400	25579524096	22658678784	3249	78961	11296321	2842275969	2512114641	12321	6345361	1868919361	12047477121	22608430321	77841	11282881	2842062721	2517530625	28561	707281	101626561	25579843969	22608430321	112225	57138481	16820793025	1.08426E+11	2.03474E+11	703921	101586241	25579204225
North	Peshawar	6	30	60	612	570	-12	30	-432	1260	1710	-30	-60	-612	-576	18	90	180	1836	1710	-36	90	-1296	3780	5130	-90	-180	-1836	-1728	7	31	61	613	571	-11	31	-431	1261	1711	-29	-59	-611	-575	19	91	181	1837	1711	-35	91	-1295	3781	5131	-89	-179	-1835	-1727	6	30	60	612	570	-12	30	-432	1260	1710	-30	-60	-612	-576	18	90	180	1836	1710	-36	90	-1296	3780	5130	-90	-180	-1836	-1728	7	31	61	613	571	-11	31	-431	1261	1711	-29	-59	-611	-575	19	91	181	1837	1711	-35	91	-1295	3781	5131	-89	-179	-1835	-1727	6	30	60	612	570	-12	30	-432	1260	1710	-30	-60	-612	-576	18	90	180	1836	1710	-36	90	-1296	3780	5130	-90	-180	-1836	-1728	7	31	61	613	571	-11	31	-431	1261	1711	-29	-59	-611	-575	19	91	181	1837	1711	-35	91	-1295	3781	5131	-89	-179	-1835	-1727	6	30	60	612	570	-12	30	-432	1260	1710	-30	-60	-612	-576	18	90	180	1836	1710	-36	90	-1296	3780	5130	-90	-180	-1836	-1728	7	31	61	613	571	-11	31	-431	1261	1711	-29	-59	-611	-575	19	91	181	1837	1711	-35	91	-1295	3781	5131	-89	-179	-1835	-1727	36	900	3600	374544	324900	144	900	186624	1587600	2924100	900	3600	374544	331776	324	8100	32400	3370896	2924100	1296	8100	1679616	14288400	26316900	8100	32400	3370896	2985984	49	961	3721	375769	326041	121	961	185761	1590121	2927521	841	3481	373321	330625	361	8281	32761	3374569	2927521	1225	8281	1677025	14295961	26327161	7921	32041	3367225	2982529	36	900	3600	374544	324900	144	900	186624	1587600	2924100	900	3600	374544	331776	324	8100	32400	3370896	2924100	1296	8100	1679616	14288400	26316900	8100	32400	3370896	2985984	49	961	3721	375769	326041	121	961	185761	1590121	2927521	841	3481	373321	330625	361	8281	32761	3374569	2927521	1225	8281	1677025	14295961	26327161	7921	32041	3367225
South	Karachi	9	45	117	1377	1287	-18	18	-1026	2835	3861	-45	-117	-1377	-1296	27	135	351	4131	3861	-54	54	-3078	8505	11583	-135	-351	-4131	-3888	10	46	118	1378	1288	-17	19	-1025	2836	3862	-44	-116	-1376	-1295	28	136	352	4132	3862	-53	55	-3077	8506	11584	-134	-350	-4130	-3887	9	45	117	1377	1287	-18	18	-1026	2835	3861	-45	-117	-1377	-1296	27	135	351	4131	3861	-54	54	-3078	8505	11583	-135	-351	-4131	-3888	10	46	118	1378	1288	-17	19	-1025	2836	3862	-44	-116	-1376	-1295	28	136	352	4132	3862	-53	55	-3077	8506	11584	-134	-350	-4130	-3887	9	45	117	1377	1287	-18	18	-1026	2835	3861	-45	-117	-1377	-1296	27	135	351	4131	3861	-54	54	-3078	8505	11583	-135	-351	-4131	-3888	10	46	118	1378	1288	-17	19	-1025	2836	3862	-44	-116	-1376	-1295	28	136	352	4132	3862	-53	55	-3077	8506	11584	-134	-350	-4130	-3887	9	45	117	1377	1287	-18	18	-1026	2835	3861	-45	-117	-1377	-1296	27	135	351	4131	3861	-54	54	-3078	8505	11583	-135	-351	-4131	-3888	10	46	118	1378	1288	-17	19	-1025	2836	3862	-44	-116	-1376	-1295	28	136	352	4132	3862	-53	55	-3077	8506	11584	-134	-350	-4130	-3887	81	2025	13689	1896129	1656369	324	324	1052676	8037225	14907321	2025	13689	1896129	1679616	729	18225	123201	17065161	14907321	2916	2916	9474084	72335025	134165889	18225	123201	17065161	15116544	100	2116	13924	1898884	1658944	289	361	1050625	8042896	14915044	1936	13456	1893376	1677025	784	18496	123904	17073424	14915044	2809	3025	9467929	72352036	134189056	17956	122500	17056900	15108769	81	2025	13689	1896129	1656369	324	324	1052676	8037225	14907321	2025	13689	1896129	1679616	729	18225	123201	17065161	14907321	2916	2916	9474084	72335025	134165889	18225	123201	17065161	15116544	100	2116	13924	1898884	1658944	289	361	1050625	8042896	14915044	1936	13456	1893376	1677025	784	18496	123904	17073424	14915044	2809	3025	9467929	72352036	134189056	17956	122500	17056900

<tbody>
</tbody>

Region

WBC Name

July

August

September

October

November

December

January

February

March

April

May

Center

Bhawalpur

?

?

?

?

?

?

?

?

?

?

?

Center

Faislabad

?

?

?

?

?

?

?

?

?

?

?

Center

Gujranwala

?

?

?

?

?

?

?

?

?

?

?

Center

Lahore

?

?

?

?

?

?

?

?

?

?

?

Center

Multan

?

?

?

?

?

?

?

?

?

?

?

North

Islamabad

?

?

?

?

?

?

?

?

?

?

?

North

Peshawar

?

?

?

?

?

?

?

?

?

?

?

South

Karachi

?

?

?

?

?

?

?

?

?

?

?

<tbody>
</tbody>

Thanks.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1061336-how-calculate-date-data-sumif-sumifs.html

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.