sumifs

zoharb · Jul 1, 2024

Respected,
needs formula using sumif to sum sales data based on date, city, agent
Has done some little , need complete formula but I cant do it .
Has attached my current work
file with all data is uploaded --- SUMIFS
Zohar Batterywala

hagia_sofia · Jul 1, 2024

Could you possibly upload a screenshot of your data?

Rhodie72 · Jul 1, 2024

					Product ID	Order Date	CITY	agent	Month	Year	Retail Price	Order Quantity	Total (Before Tax)	Tax Due	Order Total
					1049	1-Jan-22	dubai	atiq	1	2022	1,200	2	2,400	120	2,520
					1059	1-Jan-22	abu dabhi	prakash	1	2022	2,000	2	4,000	200	4,200
Q1 MONTHLY TOTALS	1065	1-Jan-22	ras al khaimah	george	1	2022	1,200	2	2,400	120	2,520
	2022	2023	% Increase		1050	2-Jan-22	dar es salam	mobodo	1	2022	1,500	1	1,500	-	1,500
	330500	453830	37.32%		1060	2-Jan-22	darESsalam	simon	1	2022	2,500	1	2,500	125	2,625
					1066	2-Jan-22			1	2022	1,500	1	1,500	-	1,500
					1051	3-Jan-22			1	2022	1,800	3	5,400	270	5,670
					1067	3-Jan-22			1	2022	1,800	3	5,400	270	5,670
Q1 MONTHLY TOTALS	1052	4-Jan-22			1	2022	2,100	1	2,100	105	2,205
	2022	2023	% Increase		1068	4-Jan-22			1	2022	2,100	1	2,100	105	2,205
January	101595	143875	41.62%		1053	5-Jan-22			1	2022	1,300	2	2,600	130	2,730
February	113445	152250	34.21%		1069	5-Jan-22			1	2022	1,300	2	2,600	130	2,730
March	115460	162810	41.01%		1054	6-Jan-22			1	2022	1,600	1	1,600	-	1,600
	330500	458935			1070	6-Jan-22			1	2022	1,600	1	1,600	-	1,600
					1071	7-Jan-22			1	2022	2,200	2	4,400	220	4,620
					1072	8-Jan-22			1	2022	2,500	1	2,500	125	2,625
					1061	13-Jan-22			1	2022	1,900	3	5,700	285	5,985
					1062	14-Jan-22			1	2022	2,200	1	2,200	110	2,310
					1055	15-Jan-22			1	2022	2,000	2	4,000	200	4,200
					1063	15-Jan-22			1	2022	2,000	2	4,000	200	4,200
					1056	16-Jan-22			1	2022	2,300	1	2,300	115	2,415
					1064	16-Jan-22			1	2022	2,300	1	2,300	115	2,415
					1057	17-Jan-22			1	2022	3,000	2	6,000	300	6,300
					1058	18-Jan-22			1	2022	3,500	1	3,500	175	3,675
					1073	21-Jan-22			1	2022	1,100	2	2,200	110	2,310
					1074	22-Jan-22			1	2022	1,400	1	1,400	-	1,400
					1075	23-Jan-22			1	2022	1,700	3	5,100	255	5,355
					1076	24-Jan-22			1	2022	2,000	1	2,000	-	2,000
					1077	25-Jan-22			1	2022	1,500	2	3,000	150	3,150
					1078	26-Jan-22			1	2022	1,800	1	1,800	-	1,800
					1079	27-Jan-22			1	2022	2,300	2	4,600	230	4,830
					1080	28-Jan-22			1	2022	2,600	1	2,600	130	2,730
					1182	1-Feb-22			2	2022	2,000	2	4,000	200	4,200
					1190	1-Feb-22			2	2022	1,200	2	2,400	120	2,520
					1183	2-Feb-22			2	2022	2,500	1	2,500	125	2,625
					1191	2-Feb-22			2	2022	1,500	1	1,500	-	1,500
					1184	3-Feb-22			2	2022	1,700	3	5,100	255	5,355
					1192	3-Feb-22			2	2022	1,800	3	5,400	270	5,670
					1185	4-Feb-22			2	2022	2,100	1	2,100	105	2,205
					1193	4-Feb-22			2	2022	2,100	1	2,100	105	2,205
					1186	5-Feb-22			2	2022	1,500	2	3,000	150	3,150
					1194	5-Feb-22			2	2022	1,300	2	2,600	130	2,730
					1187	6-Feb-22			2	2022	1,800	1	1,800	-	1,800
					1195	6-Feb-22			2	2022	1,600	1	1,600	-	1,600
					1188	7-Feb-22			2	2022	3,200	2	6,400	320	6,720
					1196	7-Feb-22			2	2022	2,200	2	4,400	220	4,620
					1198	7-Feb-22			2	2022	2,200	2	4,400	220	4,620
					1189	8-Feb-22			2	2022	3,700	1	3,700	185	3,885
					1197	8-Feb-22			2	2022	2,500	1	2,500	125	2,625
					1199	8-Feb-22			2	2022	2,500	1	2,500	125	2,625
					1208	11-Feb-22			2	2022	1,300	2	2,600	130	2,730
					1209	12-Feb-22			2	2022	1,600	1	1,600	-	1,600
					1176	13-Feb-22			2	2022	1,900	3	5,700	285	5,985
					1177	14-Feb-22			2	2022	2,200	1	2,200	110	2,310
					1178	15-Feb-22			2	2022	2,000	2	4,000	200	4,200
					1179	16-Feb-22			2	2022	2,300	1	2,300	115	2,415
					1180	17-Feb-22			2	2022	3,000	2	6,000	300	6,300
					1181	18-Feb-22			2	2022	3,500	1	3,500	175	3,675
					1200	21-Feb-22			2	2022	1,100	2	2,200	110	2,310
					1201	22-Feb-22			2	2022	1,400	1	1,400	-	1,400
					1202	23-Feb-22			2	2022	1,700	3	5,100	255	5,355
					1203	24-Feb-22			2	2022	2,000	1	2,000	-	2,000
					1204	25-Feb-22			2	2022	1,500	2	3,000	150	3,150
					1205	26-Feb-22			2	2022	1,800	1	1,800	-	1,800
					1206	27-Feb-22			2	2022	2,300	2	4,600	230	4,830
					1207	28-Feb-22			2	2022	2,600	1	2,600	130	2,730
					1216	1-Mar-22			3	2022	1,200	2	2,400	120	2,520
					1240	1-Mar-22			3	2022	2,000	2	4,000	200	4,200
					1217	2-Mar-22			3	2022	1,500	1	1,500	-	1,500
					1241	2-Mar-22			3	2022	2,500	1	2,500	125	2,625
					1218	3-Mar-22			3	2022	1,800	3	5,400	270	5,670
					1242	3-Mar-22			3	2022	1,700	3	5,100	255	5,355
					1219	4-Mar-22			3	2022	2,100	1	2,100	105	2,205
					1243	4-Mar-22			3	2022	2,100	1	2,100	105	2,205
					1220	5-Mar-22			3	2022	1,300	2	2,600	130	2,730
					1244	5-Mar-22			3	2022	1,500	2	3,000	150	3,150
					1221	6-Mar-22			3	2022	1,600	1	1,600	-	1,600
					1245	6-Mar-22			3	2022	1,800	1	1,800	-	1,800
					1222	7-Mar-22			3	2022	2,200	2	4,400	220	4,620
					1223	8-Mar-22			3	2022	2,500	1	2,500	125	2,625
					1232	11-Mar-22			3	2022	1,300	2	2,600	130	2,730
					1233	12-Mar-22			3	2022	1,600	1	1,600	-	1,600
					1234	13-Mar-22			3	2022	1,900	3	5,700	285	5,985
					1235	14-Mar-22			3	2022	2,200	1	2,200	110	2,310
					1236	15-Mar-22			3	2022	2,000	2	4,000	200	4,200
					1237	16-Mar-22			3	2022	2,300	1	2,300	115	2,415
					1238	17-Mar-22			3	2022	3,000	2	6,000	300	6,300
					1239	18-Mar-22			3	2022	3,500	1	3,500	175	3,675
					1224	21-Mar-22			3	2022	1,100	2	2,200	110	2,310
					1225	22-Mar-22			3	2022	1,400	1	1,400	-	1,400
					1210	23-Mar-22			3	2022	1,700	3	5,100	255	5,355
					1226	23-Mar-22			3	2022	1,700	3	5,100	255	5,355
					1211	24-Mar-22			3	2022	2,000	1	2,000	-	2,000
					1227	24-Mar-22			3	2022	2,000	1	2,000	-	2,000
					1212	25-Mar-22			3	2022	1,500	2	3,000	150	3,150
					1228	25-Mar-22			3	2022	1,500	2	3,000	150	3,150
					1213	26-Mar-22			3	2022	1,800	1	1,800	-	1,800
					1229	26-Mar-22			3	2022	1,800	1	1,800	-	1,800
					1214	27-Mar-22			3	2022	2,300	2	4,600	230	4,830
					1230	27-Mar-22			3	2022	2,300	2	4,600	230	4,830
					1215	28-Mar-22			3	2022	2,600	1	2,600	130	2,730
					1231	28-Mar-22			3	2022	2,600	1	2,600	130	2,730
					1107	1-Jan-23			1	2023	1,200	2	2,400	120	2,520
					1131	1-Jan-23			1	2023	2,000	2	4,000	200	4,200
					1108	2-Jan-23			1	2023	1,500	1	1,500	-	1,500
					1132	2-Jan-23			1	2023	2,500	1	2,500	125	2,625
					1109	3-Jan-23			1	2023	1,800	3	5,400	270	5,670
					1133	3-Jan-23			1	2023	1,700	3	5,100	255	5,355
					1094	4-Jan-23			1	2023	2,100	1	2,100	105	2,205
					1110	4-Jan-23			1	2023	2,100	1	2,100	105	2,205
					1134	4-Jan-23			1	2023	2,100	1	2,100	105	2,205
					1095	5-Jan-23			1	2023	1,300	2	2,600	130	2,730
					1111	5-Jan-23			1	2023	1,300	2	2,600	130	2,730
					1135	5-Jan-23			1	2023	1,500	2	3,000	150	3,150
					1096	6-Jan-23			1	2023	1,600	1	1,600	-	1,600
					1112	6-Jan-23			1	2023	1,600	1	1,600	-	1,600
					1136	6-Jan-23			1	2023	1,800	1	1,800	-	1,800
					1097	7-Jan-23			1	2023	2,200	2	4,400	220	4,620
					1113	7-Jan-23			1	2023	2,200	2	4,400	220	4,620
					1137	7-Jan-23			1	2023	3,200	2	6,400	320	6,720
					1098	8-Jan-23			1	2023	2,500	1	2,500	125	2,625
					1114	8-Jan-23			1	2023	2,500	1	2,500	125	2,625
					1138	8-Jan-23			1	2023	3,700	1	3,700	185	3,885
					1123	11-Jan-23			1	2023	1,300	2	2,600	130	2,730
					1124	12-Jan-23			1	2023	1,600	1	1,600	-	1,600
					1125	13-Jan-23			1	2023	1,900	3	5,700	285	5,985
					1126	14-Jan-23			1	2023	2,200	1	2,200	110	2,310
					1127	15-Jan-23			1	2023	2,000	2	4,000	200	4,200
					1128	16-Jan-23			1	2023	2,300	1	2,300	115	2,415
					1129	17-Jan-23			1	2023	3,000	2	6,000	300	6,300
					1130	18-Jan-23			1	2023	3,500	1	3,500	175	3,675
					1099	21-Jan-23			1	2023	1,100	2	2,200	110	2,310
					1115	21-Jan-23			1	2023	1,100	2	2,200	110	2,310
					1100	22-Jan-23			1	2023	1,400	1	1,400	-	1,400
					1116	22-Jan-23			1	2023	1,400	1	1,400	-	1,400
					1101	23-Jan-23			1	2023	1,700	3	5,100	255	5,355
					1117	23-Jan-23			1	2023	1,700	3	5,100	255	5,355
					1102	24-Jan-23			1	2023	2,000	1	2,000	-	2,000
					1118	24-Jan-23			1	2023	2,000	1	2,000	-	2,000
					1103	25-Jan-23			1	2023	1,500	2	3,000	150	3,150
					1119	25-Jan-23			1	2023	1,500	2	3,000	150	3,150
					1104	26-Jan-23			1	2023	1,800	1	1,800	-	1,800
					1120	26-Jan-23			1	2023	1,800	1	1,800	-	1,800
					1105	27-Jan-23			1	2023	2,300	2	4,600	230	4,830
					1121	27-Jan-23			1	2023	2,300	2	4,600	230	4,830
					1106	28-Jan-23			1	2023	2,600	1	2,600	130	2,730
					1122	28-Jan-23			1	2023	2,600	1	2,600	130	2,730
					1041	1-Feb-23			2	2023	150	2	300	-	300
					1153	1-Feb-23			2	2023	1,200	2	2,400	120	2,520
					1042	2-Feb-23			2	2023	200	1	200	-	200
					1154	2-Feb-23			2	2023	1,500	1	1,500	-	1,500
					1043	3-Feb-23			2	2023	400	3	1,200	-	1,200
					1155	3-Feb-23			2	2023	1,800	3	5,400	270	5,670
					1044	4-Feb-23			2	2023	600	1	600	-	600
					1081	4-Feb-23			2	2023	2,100	1	2,100	105	2,205
					1045	5-Feb-23			2	2023	1,800	2	3,600	180	3,780
					1082	5-Feb-23			2	2023	1,300	2	2,600	130	2,730
					1046	6-Feb-23			2	2023	2,400	1	2,400	120	2,520
					1083	6-Feb-23			2	2023	1,600	1	1,600	-	1,600
					1047	7-Feb-23			2	2023	2,100	2	4,200	210	4,410
					1084	7-Feb-23			2	2023	2,200	2	4,400	220	4,620
					1048	8-Feb-23			2	2023	2,600	1	2,600	130	2,730
					1085	8-Feb-23			2	2023	2,500	1	2,500	125	2,625
					1033	19-Feb-23			2	2023	1,200	2	2,400	120	2,520
					1139	19-Feb-23			2	2023	1,200	2	2,400	120	2,520
					1034	20-Feb-23			2	2023	1,500	1	1,500	-	1,500
					1140	20-Feb-23			2	2023	1,500	1	1,500	-	1,500
					1035	21-Feb-23			2	2023	2,800	3	8,400	420	8,820
					1086	21-Feb-23			2	2023	1,100	2	2,200	110	2,310
					1141	21-Feb-23			2	2023	2,800	3	8,400	420	8,820
					1036	22-Feb-23			2	2023	3,200	1	3,200	160	3,360
					1087	22-Feb-23			2	2023	1,400	1	1,400	-	1,400
					1142	22-Feb-23			2	2023	3,200	1	3,200	160	3,360
					1146	22-Feb-23			2	2023	1,400	1	1,400	-	1,400
					1037	23-Feb-23			2	2023	2,000	2	4,000	200	4,200
					1088	23-Feb-23			2	2023	1,700	3	5,100	255	5,355
					1143	23-Feb-23			2	2023	2,000	2	4,000	200	4,200
					1147	23-Feb-23			2	2023	1,700	3	5,100	255	5,355
					1038	24-Feb-23			2	2023	2,400	1	2,400	120	2,520
					1089	24-Feb-23			2	2023	2,000	1	2,000	-	2,000
					1144	24-Feb-23			2	2023	2,400	1	2,400	120	2,520
					1148	24-Feb-23			2	2023	2,000	1	2,000	-	2,000
					1039	25-Feb-23			2	2023	2,900	2	5,800	290	6,090
					1090	25-Feb-23			2	2023	1,500	2	3,000	150	3,150
					1145	25-Feb-23			2	2023	2,900	2	5,800	290	6,090
					1149	25-Feb-23			2	2023	1,500	2	3,000	150	3,150
					1040	26-Feb-23			2	2023	3,300	1	3,300	165	3,465
					1091	26-Feb-23			2	2023	1,800	1	1,800	-	1,800
					1150	26-Feb-23			2	2023	1,800	1	1,800	-	1,800
					1092	27-Feb-23			2	2023	2,300	2	4,600	230	4,830
					1151	27-Feb-23			2	2023	2,300	2	4,600	230	4,830
					1093	28-Feb-23			2	2023	2,600	1	2,600	130	2,730
					1152	28-Feb-23			2	2023	2,600	1	2,600	130	2,730
					1001	1-Mar-23			3	2023	1,200	2	2,400	120	2,520
					1025	1-Mar-23			3	2023	2,000	2	4,000	200	4,200
					1156	1-Mar-23			3	2023	1,200	2	2,400	120	2,520
					1002	2-Mar-23			3	2023	1,500	1	1,500	-	1,500
					1026	2-Mar-23			3	2023	2,500	1	2,500	125	2,625
					1157	2-Mar-23			3	2023	1,500	1	1,500	-	1,500
					1003	3-Mar-23			3	2023	1,800	3	5,400	270	5,670
					1027	3-Mar-23			3	2023	1,700	3	5,100	255	5,355
					1158	3-Mar-23			3	2023	1,800	3	5,400	270	5,670
					1004	4-Mar-23			3	2023	2,100	1	2,100	105	2,205
					1028	4-Mar-23			3	2023	2,100	1	2,100	105	2,205
					1159	4-Mar-23			3	2023	2,100	1	2,100	105	2,205
					1005	5-Mar-23			3	2023	1,300	2	2,600	130	2,730
					1029	5-Mar-23			3	2023	1,500	2	3,000	150	3,150
					1160	5-Mar-23			3	2023	1,300	2	2,600	130	2,730
					1006	6-Mar-23			3	2023	1,600	1	1,600	-	1,600
					1030	6-Mar-23			3	2023	1,800	1	1,800	-	1,800
					1161	6-Mar-23			3	2023	1,600	1	1,600	-	1,600
					1007	7-Mar-23			3	2023	2,200	2	4,400	220	4,620
					1031	7-Mar-23			3	2023	3,200	2	6,400	320	6,720
					1162	7-Mar-23			3	2023	2,200	2	4,400	220	4,620
					1008	8-Mar-23			3	2023	2,500	1	2,500	125	2,625
					1032	8-Mar-23			3	2023	3,700	1	3,700	185	3,885
					1163	8-Mar-23			3	2023	2,500	1	2,500	125	2,625
					1017	11-Mar-23			3	2023	1,300	2	2,600	130	2,730
					1172	11-Mar-23			3	2023	1,300	2	2,600	130	2,730
					1018	12-Mar-23			3	2023	1,600	1	1,600	-	1,600
					1173	12-Mar-23			3	2023	1,600	1	1,600	-	1,600
					1019	13-Mar-23			3	2023	1,900	3	5,700	285	5,985
					1174	13-Mar-23			3	2023	1,900	3	5,700	285	5,985
					1020	14-Mar-23			3	2023	2,200	1	2,200	110	2,310
					1175	14-Mar-23			3	2023	2,200	1	2,200	110	2,310
					1021	15-Mar-23			3	2023	2,000	2	4,000	200	4,200
					1022	16-Mar-23			3	2023	2,300	1	2,300	115	2,415
					1023	17-Mar-23			3	2023	3,000	2	6,000	300	6,300
					1024	18-Mar-23			3	2023	3,500	1	3,500	175	3,675
					1009	21-Mar-23			3	2023	1,100	2	2,200	110	2,310
					1164	21-Mar-23			3	2023	1,100	2	2,200	110	2,310
					1010	22-Mar-23			3	2023	1,400	1	1,400	-	1,400
					1165	22-Mar-23			3	2023	1,400	1	1,400	-	1,400
					1011	23-Mar-23			3	2023	1,700	3	5,100	255	5,355
					1166	23-Mar-23			3	2023	1,700	3	5,100	255	5,355
					1012	24-Mar-23			3	2023	2,000	1	2,000	-	2,000
					1167	24-Mar-23			3	2023	2,000	1	2,000	-	2,000
					1013	25-Mar-23			3	2023	1,500	2	3,000	150	3,150
					1168	25-Mar-23			3	2023	1,500	2	3,000	150	3,150
					1014	26-Mar-23			3	2023	1,800	1	1,800	-	1,800
					1169	26-Mar-23			3	2023	1,800	1	1,800	-	1,800
					1015	27-Mar-23			3	2023	2,300	2	4,600	230	4,830
					1170	27-Mar-23			3	2023	2,300	2	4,600	230	4,830
					1016	28-Mar-23			3	2023	1,600	1	1,600	-	1,600
					1171	28-Mar-23			3	2023	2,600	1	2,600	130	2,730

zoharb · Jul 1, 2024

hello

hagia_sofia said:
Could you possibly upload a screenshot of your data?

zoharb · Jul 1, 2024

Rhodie72 said:
Product ID Order Date CITY agent Month Year Retail Price Order Quantity Total (Before Tax) Tax Due Order Total
1049
1-Jan-22
dubai atiq
1
2022
1,200
2
2,400 120 2,520
1059
1-Jan-22
abu dabhi prakash
1
2022
2,000
2
4,000 200 4,200
Q1 MONTHLY TOTALS
1065
1-Jan-22
ras al khaimah george
1
2022
1,200
2
2,400 120 2,520
2022 2023 % Increase
1050
2-Jan-22
dar es salam mobodo
1
2022
1,500
1
1,500 - 1,500
330500
453830
37.32%
1060
2-Jan-22
darESsalam simon
1
2022
2,500
1
2,500 125 2,625
1066
2-Jan-22
1
2022
1,500
1
1,500 - 1,500
1051
3-Jan-22
1
2022
1,800
3
5,400 270 5,670
1067
3-Jan-22
1
2022
1,800
3
5,400 270 5,670
Q1 MONTHLY TOTALS
1052
4-Jan-22
1
2022
2,100
1
2,100 105 2,205
2022 2023 % Increase
1068
4-Jan-22
1
2022
2,100
1
2,100 105 2,205
January
101595
143875
41.62%
1053
5-Jan-22
1
2022
1,300
2
2,600 130 2,730
February
113445
152250
34.21%
1069
5-Jan-22
1
2022
1,300
2
2,600 130 2,730
March
115460
162810
41.01%
1054
6-Jan-22
1
2022
1,600
1
1,600 - 1,600
330500
458935
1070
6-Jan-22
1
2022
1,600
1
1,600 - 1,600
1071
7-Jan-22
1
2022
2,200
2
4,400 220 4,620
1072
8-Jan-22
1
2022
2,500
1
2,500 125 2,625
1061
13-Jan-22
1
2022
1,900
3
5,700 285 5,985
1062
14-Jan-22
1
2022
2,200
1
2,200 110 2,310
1055
15-Jan-22
1
2022
2,000
2
4,000 200 4,200
1063
15-Jan-22
1
2022
2,000
2
4,000 200 4,200
1056
16-Jan-22
1
2022
2,300
1
2,300 115 2,415
1064
16-Jan-22
1
2022
2,300
1
2,300 115 2,415
1057
17-Jan-22
1
2022
3,000
2
6,000 300 6,300
1058
18-Jan-22
1
2022
3,500
1
3,500 175 3,675
1073
21-Jan-22
1
2022
1,100
2
2,200 110 2,310
1074
22-Jan-22
1
2022
1,400
1
1,400 - 1,400
1075
23-Jan-22
1
2022
1,700
3
5,100 255 5,355
1076
24-Jan-22
1
2022
2,000
1
2,000 - 2,000
1077
25-Jan-22
1
2022
1,500
2
3,000 150 3,150
1078
26-Jan-22
1
2022
1,800
1
1,800 - 1,800
1079
27-Jan-22
1
2022
2,300
2
4,600 230 4,830
1080
28-Jan-22
1
2022
2,600
1
2,600 130 2,730
1182
1-Feb-22
2
2022
2,000
2
4,000 200 4,200
1190
1-Feb-22
2
2022
1,200
2
2,400 120 2,520
1183
2-Feb-22
2
2022
2,500
1
2,500 125 2,625
1191
2-Feb-22
2
2022
1,500
1
1,500 - 1,500
1184
3-Feb-22
2
2022
1,700
3
5,100 255 5,355
1192
3-Feb-22
2
2022
1,800
3
5,400 270 5,670
1185
4-Feb-22
2
2022
2,100
1
2,100 105 2,205
1193
4-Feb-22
2
2022
2,100
1
2,100 105 2,205
1186
5-Feb-22
2
2022
1,500
2
3,000 150 3,150
1194
5-Feb-22
2
2022
1,300
2
2,600 130 2,730
1187
6-Feb-22
2
2022
1,800
1
1,800 - 1,800
1195
6-Feb-22
2
2022
1,600
1
1,600 - 1,600
1188
7-Feb-22
2
2022
3,200
2
6,400 320 6,720
1196
7-Feb-22
2
2022
2,200
2
4,400 220 4,620
1198
7-Feb-22
2
2022
2,200
2
4,400 220 4,620
1189
8-Feb-22
2
2022
3,700
1
3,700 185 3,885
1197
8-Feb-22
2
2022
2,500
1
2,500 125 2,625
1199
8-Feb-22
2
2022
2,500
1
2,500 125 2,625
1208
11-Feb-22
2
2022
1,300
2
2,600 130 2,730
1209
12-Feb-22
2
2022
1,600
1
1,600 - 1,600
1176
13-Feb-22
2
2022
1,900
3
5,700 285 5,985
1177
14-Feb-22
2
2022
2,200
1
2,200 110 2,310
1178
15-Feb-22
2
2022
2,000
2
4,000 200 4,200
1179
16-Feb-22
2
2022
2,300
1
2,300 115 2,415
1180
17-Feb-22
2
2022
3,000
2
6,000 300 6,300
1181
18-Feb-22
2
2022
3,500
1
3,500 175 3,675
1200
21-Feb-22
2
2022
1,100
2
2,200 110 2,310
1201
22-Feb-22
2
2022
1,400
1
1,400 - 1,400
1202
23-Feb-22
2
2022
1,700
3
5,100 255 5,355
1203
24-Feb-22
2
2022
2,000
1
2,000 - 2,000
1204
25-Feb-22
2
2022
1,500
2
3,000 150 3,150
1205
26-Feb-22
2
2022
1,800
1
1,800 - 1,800
1206
27-Feb-22
2
2022
2,300
2
4,600 230 4,830
1207
28-Feb-22
2
2022
2,600
1
2,600 130 2,730
1216
1-Mar-22
3
2022
1,200
2
2,400 120 2,520
1240
1-Mar-22
3
2022
2,000
2
4,000 200 4,200
1217
2-Mar-22
3
2022
1,500
1
1,500 - 1,500
1241
2-Mar-22
3
2022
2,500
1
2,500 125 2,625
1218
3-Mar-22
3
2022
1,800
3
5,400 270 5,670
1242
3-Mar-22
3
2022
1,700
3
5,100 255 5,355
1219
4-Mar-22
3
2022
2,100
1
2,100 105 2,205
1243
4-Mar-22
3
2022
2,100
1
2,100 105 2,205
1220
5-Mar-22
3
2022
1,300
2
2,600 130 2,730
1244
5-Mar-22
3
2022
1,500
2
3,000 150 3,150
1221
6-Mar-22
3
2022
1,600
1
1,600 - 1,600
1245
6-Mar-22
3
2022
1,800
1
1,800 - 1,800
1222
7-Mar-22
3
2022
2,200
2
4,400 220 4,620
1223
8-Mar-22
3
2022
2,500
1
2,500 125 2,625
1232
11-Mar-22
3
2022
1,300
2
2,600 130 2,730
1233
12-Mar-22
3
2022
1,600
1
1,600 - 1,600
1234
13-Mar-22
3
2022
1,900
3
5,700 285 5,985
1235
14-Mar-22
3
2022
2,200
1
2,200 110 2,310
1236
15-Mar-22
3
2022
2,000
2
4,000 200 4,200
1237
16-Mar-22
3
2022
2,300
1
2,300 115 2,415
1238
17-Mar-22
3
2022
3,000
2
6,000 300 6,300
1239
18-Mar-22
3
2022
3,500
1
3,500 175 3,675
1224
21-Mar-22
3
2022
1,100
2
2,200 110 2,310
1225
22-Mar-22
3
2022
1,400
1
1,400 - 1,400
1210
23-Mar-22
3
2022
1,700
3
5,100 255 5,355
1226
23-Mar-22
3
2022
1,700
3
5,100 255 5,355
1211
24-Mar-22
3
2022
2,000
1
2,000 - 2,000
1227
24-Mar-22
3
2022
2,000
1
2,000 - 2,000
1212
25-Mar-22
3
2022
1,500
2
3,000 150 3,150
1228
25-Mar-22
3
2022
1,500
2
3,000 150 3,150
1213
26-Mar-22
3
2022
1,800
1
1,800 - 1,800
1229
26-Mar-22
3
2022
1,800
1
1,800 - 1,800
1214
27-Mar-22
3
2022
2,300
2
4,600 230 4,830
1230
27-Mar-22
3
2022
2,300
2
4,600 230 4,830
1215
28-Mar-22
3
2022
2,600
1
2,600 130 2,730
1231
28-Mar-22
3
2022
2,600
1
2,600 130 2,730
1107
1-Jan-23
1
2023
1,200
2
2,400 120 2,520
1131
1-Jan-23
1
2023
2,000
2
4,000 200 4,200
1108
2-Jan-23
1
2023
1,500
1
1,500 - 1,500
1132
2-Jan-23
1
2023
2,500
1
2,500 125 2,625
1109
3-Jan-23
1
2023
1,800
3
5,400 270 5,670
1133
3-Jan-23
1
2023
1,700
3
5,100 255 5,355
1094
4-Jan-23
1
2023
2,100
1
2,100 105 2,205
1110
4-Jan-23
1
2023
2,100
1
2,100 105 2,205
1134
4-Jan-23
1
2023
2,100
1
2,100 105 2,205
1095
5-Jan-23
1
2023
1,300
2
2,600 130 2,730
1111
5-Jan-23
1
2023
1,300
2
2,600 130 2,730
1135
5-Jan-23
1
2023
1,500
2
3,000 150 3,150
1096
6-Jan-23
1
2023
1,600
1
1,600 - 1,600
1112
6-Jan-23
1
2023
1,600
1
1,600 - 1,600
1136
6-Jan-23
1
2023
1,800
1
1,800 - 1,800
1097
7-Jan-23
1
2023
2,200
2
4,400 220 4,620
1113
7-Jan-23
1
2023
2,200
2
4,400 220 4,620
1137
7-Jan-23
1
2023
3,200
2
6,400 320 6,720
1098
8-Jan-23
1
2023
2,500
1
2,500 125 2,625
1114
8-Jan-23
1
2023
2,500
1
2,500 125 2,625
1138
8-Jan-23
1
2023
3,700
1
3,700 185 3,885
1123
11-Jan-23
1
2023
1,300
2
2,600 130 2,730
1124
12-Jan-23
1
2023
1,600
1
1,600 - 1,600
1125
13-Jan-23
1
2023
1,900
3
5,700 285 5,985
1126
14-Jan-23
1
2023
2,200
1
2,200 110 2,310
1127
15-Jan-23
1
2023
2,000
2
4,000 200 4,200
1128
16-Jan-23
1
2023
2,300
1
2,300 115 2,415
1129
17-Jan-23
1
2023
3,000
2
6,000 300 6,300
1130
18-Jan-23
1
2023
3,500
1
3,500 175 3,675
1099
21-Jan-23
1
2023
1,100
2
2,200 110 2,310
1115
21-Jan-23
1
2023
1,100
2
2,200 110 2,310
1100
22-Jan-23
1
2023
1,400
1
1,400 - 1,400
1116
22-Jan-23
1
2023
1,400
1
1,400 - 1,400
1101
23-Jan-23
1
2023
1,700
3
5,100 255 5,355
1117
23-Jan-23
1
2023
1,700
3
5,100 255 5,355
1102
24-Jan-23
1
2023
2,000
1
2,000 - 2,000
1118
24-Jan-23
1
2023
2,000
1
2,000 - 2,000
1103
25-Jan-23
1
2023
1,500
2
3,000 150 3,150
1119
25-Jan-23
1
2023
1,500
2
3,000 150 3,150
1104
26-Jan-23
1
2023
1,800
1
1,800 - 1,800
1120
26-Jan-23
1
2023
1,800
1
1,800 - 1,800
1105
27-Jan-23
1
2023
2,300
2
4,600 230 4,830
1121
27-Jan-23
1
2023
2,300
2
4,600 230 4,830
1106
28-Jan-23
1
2023
2,600
1
2,600 130 2,730
1122
28-Jan-23
1
2023
2,600
1
2,600 130 2,730
1041
1-Feb-23
2
2023
150
2
300 - 300
1153
1-Feb-23
2
2023
1,200
2
2,400 120 2,520
1042
2-Feb-23
2
2023
200
1
200 - 200
1154
2-Feb-23
2
2023
1,500
1
1,500 - 1,500
1043
3-Feb-23
2
2023
400
3
1,200 - 1,200
1155
3-Feb-23
2
2023
1,800
3
5,400 270 5,670
1044
4-Feb-23
2
2023
600
1
600 - 600
1081
4-Feb-23
2
2023
2,100
1
2,100 105 2,205
1045
5-Feb-23
2
2023
1,800
2
3,600 180 3,780
1082
5-Feb-23
2
2023
1,300
2
2,600 130 2,730
1046
6-Feb-23
2
2023
2,400
1
2,400 120 2,520
1083
6-Feb-23
2
2023
1,600
1
1,600 - 1,600
1047
7-Feb-23
2
2023
2,100
2
4,200 210 4,410
1084
7-Feb-23
2
2023
2,200
2
4,400 220 4,620
1048
8-Feb-23
2
2023
2,600
1
2,600 130 2,730
1085
8-Feb-23
2
2023
2,500
1
2,500 125 2,625
1033
19-Feb-23
2
2023
1,200
2
2,400 120 2,520
1139
19-Feb-23
2
2023
1,200
2
2,400 120 2,520
1034
20-Feb-23
2
2023
1,500
1
1,500 - 1,500
1140
20-Feb-23
2
2023
1,500
1
1,500 - 1,500
1035
21-Feb-23
2
2023
2,800
3
8,400 420 8,820
1086
21-Feb-23
2
2023
1,100
2
2,200 110 2,310
1141
21-Feb-23
2
2023
2,800
3
8,400 420 8,820
1036
22-Feb-23
2
2023
3,200
1
3,200 160 3,360
1087
22-Feb-23
2
2023
1,400
1
1,400 - 1,400
1142
22-Feb-23
2
2023
3,200
1
3,200 160 3,360
1146
22-Feb-23
2
2023
1,400
1
1,400 - 1,400
1037
23-Feb-23
2
2023
2,000
2
4,000 200 4,200
1088
23-Feb-23
2
2023
1,700
3
5,100 255 5,355
1143
23-Feb-23
2
2023
2,000
2
4,000 200 4,200
1147
23-Feb-23
2
2023
1,700
3
5,100 255 5,355
1038
24-Feb-23
2
2023
2,400
1
2,400 120 2,520
1089
24-Feb-23
2
2023
2,000
1
2,000 - 2,000
1144
24-Feb-23
2
2023
2,400
1
2,400 120 2,520
1148
24-Feb-23
2
2023
2,000
1
2,000 - 2,000
1039
25-Feb-23
2
2023
2,900
2
5,800 290 6,090
1090
25-Feb-23
2
2023
1,500
2
3,000 150 3,150
1145
25-Feb-23
2
2023
2,900
2
5,800 290 6,090
1149
25-Feb-23
2
2023
1,500
2
3,000 150 3,150
1040
26-Feb-23
2
2023
3,300
1
3,300 165 3,465
1091
26-Feb-23
2
2023
1,800
1
1,800 - 1,800
1150
26-Feb-23
2
2023
1,800
1
1,800 - 1,800
1092
27-Feb-23
2
2023
2,300
2
4,600 230 4,830
1151
27-Feb-23
2
2023
2,300
2
4,600 230 4,830
1093
28-Feb-23
2
2023
2,600
1
2,600 130 2,730
1152
28-Feb-23
2
2023
2,600
1
2,600 130 2,730
1001
1-Mar-23
3
2023
1,200
2
2,400 120 2,520
1025
1-Mar-23
3
2023
2,000
2
4,000 200 4,200
1156
1-Mar-23
3
2023
1,200
2
2,400 120 2,520
1002
2-Mar-23
3
2023
1,500
1
1,500 - 1,500
1026
2-Mar-23
3
2023
2,500
1
2,500 125 2,625
1157
2-Mar-23
3
2023
1,500
1
1,500 - 1,500
1003
3-Mar-23
3
2023
1,800
3
5,400 270 5,670
1027
3-Mar-23
3
2023
1,700
3
5,100 255 5,355
1158
3-Mar-23
3
2023
1,800
3
5,400 270 5,670
1004
4-Mar-23
3
2023
2,100
1
2,100 105 2,205
1028
4-Mar-23
3
2023
2,100
1
2,100 105 2,205
1159
4-Mar-23
3
2023
2,100
1
2,100 105 2,205
1005
5-Mar-23
3
2023
1,300
2
2,600 130 2,730
1029
5-Mar-23
3
2023
1,500
2
3,000 150 3,150
1160
5-Mar-23
3
2023
1,300
2
2,600 130 2,730
1006
6-Mar-23
3
2023
1,600
1
1,600 - 1,600
1030
6-Mar-23
3
2023
1,800
1
1,800 - 1,800
1161
6-Mar-23
3
2023
1,600
1
1,600 - 1,600
1007
7-Mar-23
3
2023
2,200
2
4,400 220 4,620
1031
7-Mar-23
3
2023
3,200
2
6,400 320 6,720
1162
7-Mar-23
3
2023
2,200
2
4,400 220 4,620
1008
8-Mar-23
3
2023
2,500
1
2,500 125 2,625
1032
8-Mar-23
3
2023
3,700
1
3,700 185 3,885
1163
8-Mar-23
3
2023
2,500
1
2,500 125 2,625
1017
11-Mar-23
3
2023
1,300
2
2,600 130 2,730
1172
11-Mar-23
3
2023
1,300
2
2,600 130 2,730
1018
12-Mar-23
3
2023
1,600
1
1,600 - 1,600
1173
12-Mar-23
3
2023
1,600
1
1,600 - 1,600
1019
13-Mar-23
3
2023
1,900
3
5,700 285 5,985
1174
13-Mar-23
3
2023
1,900
3
5,700 285 5,985
1020
14-Mar-23
3
2023
2,200
1
2,200 110 2,310
1175
14-Mar-23
3
2023
2,200
1
2,200 110 2,310
1021
15-Mar-23
3
2023
2,000
2
4,000 200 4,200
1022
16-Mar-23
3
2023
2,300
1
2,300 115 2,415
1023
17-Mar-23
3
2023
3,000
2
6,000 300 6,300
1024
18-Mar-23
3
2023
3,500
1
3,500 175 3,675
1009
21-Mar-23
3
2023
1,100
2
2,200 110 2,310
1164
21-Mar-23
3
2023
1,100
2
2,200 110 2,310
1010
22-Mar-23
3
2023
1,400
1
1,400 - 1,400
1165
22-Mar-23
3
2023
1,400
1
1,400 - 1,400
1011
23-Mar-23
3
2023
1,700
3
5,100 255 5,355
1166
23-Mar-23
3
2023
1,700
3
5,100 255 5,355
1012
24-Mar-23
3
2023
2,000
1
2,000 - 2,000
1167
24-Mar-23
3
2023
2,000
1
2,000 - 2,000
1013
25-Mar-23
3
2023
1,500
2
3,000 150 3,150
1168
25-Mar-23
3
2023
1,500
2
3,000 150 3,150
1014
26-Mar-23
3
2023
1,800
1
1,800 - 1,800
1169
26-Mar-23
3
2023
1,800
1
1,800 - 1,800
1015
27-Mar-23
3
2023
2,300
2
4,600 230 4,830
1170
27-Mar-23
3
2023
2,300
2
4,600 230 4,830
1016
28-Mar-23
3
2023
1,600
1
1,600 - 1,600
1171
28-Mar-23
3
2023
2,600
1
2,600 130 2,730

Respected Rhodie72,
where I can find formula?? for this

Rhodie72 · Jul 11, 2024

sumif is the formula and you ned to create the conditions for it to work

zoharb · Jul 11, 2024

Rhodie72 said:
sumif is the formula and you ned to create the conditions for it to work

Respected, UI have made a formula to sum the amount based on month BUT I need it on combination of DAY+month+year+city +agent
=SUMIF($J$104:$J$246,1,$P$2:$P$103)

zoharb · Jul 15, 2024

Respected ,
Has made some changes. created list of unique entries using UNIQUE function and created list to select using DATA VALIDATION.
Please assist me to solve to SUMIFS formula for getting desired results
Zohar Batterywala

sumifs

zoharb

Board Regular

Excel Facts

hagia_sofia

Well-known Member

Rhodie72

Well-known Member

zoharb

Board Regular

Attachments

zoharb

Board Regular

Rhodie72

Well-known Member

zoharb

Board Regular

Attachments

zoharb

Board Regular

Attachments

Similar threads

Forum statistics

Share this page

sumifs

Board Regular

Excel Facts

Well-known Member

Well-known Member

Board Regular

Attachments

Board Regular

Well-known Member

Board Regular

Attachments

Board Regular

Attachments

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock