to make a report to get the sales of the wholesaler ,but only sum the sales of the dealers which is more than 30

[faizan1132]

I have to make a report to get the sales of the wholesaler ,but only sum the sales of the dealers which is more than 30. I want to know which formulae to use and how

region	dealers	promoter	sales	Wholesaler
RWP-C	130001	name 1	3	130001
Chakwal	13000100	name 2	82	130001
AJK	13000102	name 3	59	130001
ISB-A	13000108	name 4	80	130001
ATK	130002	name 5	9	130002
Gilgit-A	13000200	name 6	79	130002
RWP-B	13000207	name 7	100	130002
Gilgit-B	13000209	name 8	104	130002
RWP-A	13000212	name 9	87	130002
ISB-B	13000225	name 10	80	130002
TAX	13000227	name 11	9	130002
RWP-C	13000233	name 12	80	130002
Chakwal	13000234	name 13	35	130002
AJK	13000247	name 14	80	130002
ISB-A	13000263	name 15	101	130002
ATK	13000300	name 16	105	130003
Gilgit-A	130015	name 17	13	130015
RWP-B	13001500	name 18	66	130015
Gilgit-B	13001511	name 19	52	130015
RWP-A	13001519	name 20	74	130015
ISB-B	13001545	name 21	2	130015
TAX	13001555	name 22	13	130015
RWP-C	13001558	name 23	77	130015
Chakwal	130034	name 24	1	130034
AJK	13003400	name 25	80	130034
ISB-A	13003412	name 26	2	130034
ATK	13003413	name 27	2	130034
Gilgit-A	13003414	name 28	2	130034
RWP-B	13003415	name 29	2	130034
Gilgit-B	13003417	name 30	2	130034
RWP-A	130048	name 31	17	130048
ISB-B	13004800	name 32	81	130048
TAX	13004802	name 33	80	130048
RWP-C	13004808	name 34	81	130048
Chakwal	130048100	name 35	51	130048
AJK	130048101	name 36	76	130048
ISB-A	130048102	name 37	80	130048
ATK	130048103	name 38	80	130048
Gilgit-A	130048104	name 39	26	130048
RWP-B	130048105	name 40	1	130048
Gilgit-B	130048106	name 41	82	130048
RWP-A	130048107	name 42	80	130048
ISB-B	130048108	name 43	84	130048
TAX	13004811	name 44	80	130048
RWP-C	13004823	name 45	2	130048
Chakwal	13004831	name 46	80	130048
AJK	13004844	name 47	17	130048
ISB-A	13004847	name 48	2	130048
ATK	13004849	name 49	80	130048
Gilgit-A	13004860	name 50	2	130048
RWP-B	13004861	name 51	2	130048
Gilgit-B	13004884	name 52	2	130048
RWP-A	13004886	name 53	2	130048
ISB-B	13004889	name 54	82	130048
TAX	13004890	name 55	1	130048
RWP-C	13004891	name 56	80	130048
Chakwal	13004894	name 57	80	130048
AJK	13004895	name 58	2	130048
ISB-A	13004896	name 59	2	130048
ATK	13004897	name 60	80	130048
Gilgit-A	13004898	name 61	2	130048
RWP-B	130051	name 62	6	130051
Gilgit-B	13005100	name 63	81	130051
RWP-A	13005101	name 64	80	130051
ISB-B	13005102	name 65	2	130051
TAX	13005103	name 66	80	130051
RWP-C	13005105	name 67	2	130051
Chakwal	13005106	name 68	82	130051
AJK	13005109	name 69	11	130051
ISB-A	13005110	name 70	84	130051
ATK	13005117	name 71	2	130051
Gilgit-A	13005124	name 72	2	130051
RWP-B	13005126	name 73	2	130051
Gilgit-B	13005129	name 74	3	130051
RWP-A	13005131	name 75	2	130051
ISB-B	13005132	name 76	4	130051
TAX	13005133	name 77	2	130051
RWP-C	13005134	name 78	2	130051
Chakwal	13005138	name 79	2	130051
AJK	13005140	name 80	2	130051
ISB-A	13005142	name 81	80	130051
ATK	13005143	name 82	2	130051
Gilgit-A	13005144	name 83	2	130051
RWP-B	13005145	name 84	2	130051
Gilgit-B	13005146	name 85	20	130051
RWP-A	13005157	name 86	2	130051
ISB-B	13005160	name 87	2	130051
TAX	13005161	name 88	20	130051
RWP-C	13005162	name 89	20	130051
Chakwal	13005163	name 90	2	130051
AJK	13005164	name 91	80	130051
ISB-A	13007500	name 92	207	130075
ATK	13007510	name 93	2	130075
Gilgit-A	13007512	name 94	1	130075
RWP-B	130081	name 95	3	130081
Gilgit-B	13008100	name 96	64	130081
RWP-A	13008104	name 97	74	130081
ISB-B	13008106	name 98	2	130081
TAX	13008107	name 99	2	130081
RWP-C	13008109	name 100	4	130081
Chakwal	13008114	name 101	80	130081
AJK	13008116	name 102	2	130081
ISB-A	13008118	name 103	2	130081
ATK	13008120	name 104	2	130081
Gilgit-A	13008127	name 105	2	130081
RWP-B	13008128	name 106	2	130081
Gilgit-B	13008130	name 107	2	130081
RWP-A	13008133	name 108	80	130081
ISB-B	13008136	name 109	2	130081
TAX	13008137	name 110	2	130081
RWP-C	130093	name 111	82	130093
Chakwal	130096	name 112	20	130096
AJK	13009600	name 113	81	130096
ISB-A	13009601	name 114	2	130096
ATK	13009604	name 115	80	130096
Gilgit-A	13009605	name 116	2	130096
RWP-B	13009607	name 117	5	130096
Gilgit-B	13009608	name 118	2	130096
RWP-A	130096100	name 119	8	130096
ISB-B	130096101	name 120	2	130096
TAX	130096102	name 121	2	130096
RWP-C	130096103	name 122	2	130096
Chakwal	130096104	name 123	2	130096
AJK	130096105	name 124	2	130096
ISB-A	130096106	name 125	80	130096
ATK	130096108	name 126	20	130096
Gilgit-A	130096109	name 127	2	130096
RWP-B	130096110	name 128	20	130096
Gilgit-B	13009612	name 129	11	130096
RWP-A	13009613	name 130	3	130096
ISB-B	13009614	name 131	18	130096
TAX	13009616	name 132	2	130096
RWP-C	13009617	name 133	80	130096
Chakwal	13009621	name 134	2	130096
AJK	13009623	name 135	2	130096
ISB-A	13009625	name 136	80	130096
ATK	13009626	name 137	2	130096
Gilgit-A	13009627	name 138	2	130096
RWP-B	13009632	name 139	2	130096
Gilgit-B	13009633	name 140	2	130096
RWP-A	13009634	name 141	2	130096
ISB-B	13009638	name 142	2	130096
TAX	13009640	name 143	2	130096
RWP-C	13009648	name 144	2	130096
Chakwal	13009653	name 145	2	130096
AJK	13009654	name 146	2	130096
ISB-A	13009655	name 147	2	130096
ATK	13009656	name 148	2	130096
Gilgit-A	13009660	name 149	2	130096
RWP-B	13009661	name 150	80	130096
Gilgit-B	13009663	name 151	2	130096
RWP-A	13009664	name 152	3	130096
ISB-B	13009665	name 153	2	130096
TAX	13009666	name 154	2	130096
RWP-C	13009668	name 155	2	130096
Chakwal	13009669	name 156	80	130096
AJK	13009670	name 157	2	130096
ISB-A	13009671	name 158	2	130096
ATK	13009673	name 159	2	130096
Gilgit-A	13009674	name 160	2	130096
RWP-B	13009675	name 161	2	130096
Gilgit-B	13009676	name 162	20	130096
RWP-A	13009677	name 163	2	130096
ISB-B	13009678	name 164	2	130096
TAX	13009679	name 165	2	130096
RWP-C	13009680	name 166	80	130096
Chakwal	13009681	name 167	80	130096
AJK	13009682	name 168	75	130096
ISB-A	13009684	name 169	2	130096
ATK	13009685	name 170	2	130096
Gilgit-A	13009686	name 171	2	130096
RWP-B	13009687	name 172	2	130096
Gilgit-B	13009688	name 173	2	130096
RWP-A	13009689	name 174	2	130096
ISB-B	13009690	name 175	4	130096
TAX	13009691	name 176	2	130096
RWP-C	13009693	name 177	2	130096
Chakwal	13009694	name 178	2	130096
AJK	13009695	name 179	6	130096
ISB-A	13009697	name 180	2	130096
ATK	13009698	name 181	3	130096
Gilgit-A	13009699	name 182	2	130096
RWP-B	13019000	name 183	89	130190
Gilgit-B	13019001	name 184	2	130190
RWP-A	13019003	name 185	1	130190
ISB-B	13019004	name 186	2	130190
TAX	13019007	name 187	2	130190
RWP-C	13019008	name 188	2	130190
Chakwal	13019009	name 189	2	130190
AJK	130191	name 190	1	130191
ISB-A	13019100	name 191	30	130191
ATK	13019101	name 192	2	130191
Gilgit-A	13019102	name 193	2	130191
RWP-B	13019103	name 194	2	130191
Gilgit-B	13019104	name 195	2	130191
RWP-A	130194	name 196	25	130194
ISB-B	130210	name 197	4	130210
TAX	13021003	name 198	6	130210
RWP-C	13021009	name 199	20	130210
Chakwal	13021010	name 200	2	130210
AJK	13021011	name 201	16	130210
ISB-A	13021022	name 202	98	130210
ATK	13021030	name 203	2	130210
Gilgit-A	13021035	name 204	2	130210
RWP-B	13021036	name 205	20	130210
Gilgit-B	13021044	name 206	81	130210
RWP-A	13021050	name 207	5	130210
ISB-B	130233	name 208	3	130233
TAX	13023300	name 209	152	130233
RWP-C	13023301	name 210	80	130233
Chakwal	13023303	name 211	81	130233
AJK	13023307	name 212	82	130233
ISB-A	13023309	name 213	2	130233
ATK	13023310	name 214	82	130233
Gilgit-A	13023311	name 215	60	130233
RWP-B	13023312	name 216	12	130233
Gilgit-B	13023313	name 217	2	130233
RWP-A	130244	name 218	2	130244
ISB-B	13024400	name 219	81	130244
TAX	13024401	name 220	2	130244
RWP-C	13024403	name 221	2	130244
Chakwal	13024407	name 222	2	130244
AJK	13024411	name 223	2	130244
ISB-A	13024418	name 224	1	130244
ATK	13024419	name 225	40	130244
Gilgit-A	13024420	name 226	2	130244
RWP-B	130256	name 227	10	130256
Gilgit-B	13025600	name 228	80	130256
RWP-A	13025601	name 229	7	130256
ISB-B	130265	name 230	19	130265
TAX	13026500	name 231	82	130265
RWP-C	13026501	name 232	30	130265
Chakwal	13026502	name 233	80	130265
AJK	13026503	name 234	80	130265
ISB-A	13026504	name 235	80	130265
ATK	13026505	name 236	20	130265
Gilgit-A	13026506	name 237	20	130265
RWP-B	13026507	name 238	20	130265
Gilgit-B	13026509	name 239	20	130265
RWP-A	13026510	name 240	20	130265
ISB-B	13026511	name 241	2	130265
TAX	13026512	name 242	2	130265
RWP-C	13026513	name 243	2	130265
Chakwal	13026514	name 244	2	130265
AJK	13026515	name 245	2	130265
ISB-A	13026516	name 246	2	130265
ATK	13026517	name 247	39	130265
Gilgit-A	130268	name 248	5	130268
RWP-B	13026800	name 249	40	130268
Gilgit-B	13026801	name 250	2	130268
RWP-A	13026803	name 251	2	130268
ISB-B	13026804	name 252	2	130268
TAX	13026808	name 253	2	130268
RWP-C	13026811	name 254	2	130268
Chakwal	13026812	name 255	2	130268
AJK	13026816	name 256	2	130268
ISB-A	13026818	name 257	2	130268
ATK	13026820	name 258	2	130268
Gilgit-A	13027200	name 259	81	130272
RWP-B	13027204	name 260	80	130272
Gilgit-B	13027206	name 261	80	130272
RWP-A	13027207	name 262	148	130272
ISB-B	13027208	name 263	20	130272
TAX	13027209	name 264	80	130272
RWP-C	13027210	name 265	20	130272
Chakwal	13027211	name 266	1	130272
AJK	13027212	name 267	80	130272
ISB-A	13027213	name 268	1	130272
ATK	13027216	name 269	20	130272
Gilgit-A	13027217	name 270	20	130272
RWP-B	13027219	name 271	20	130272
Gilgit-B	13027220	name 272	80	130272
RWP-A	13027221	name 273	20	130272
ISB-B	13027222	name 274	80	130272
TAX	130276	name 275	2	130276
RWP-C	13027600	name 276	82	130276
Chakwal	13027602	name 277	20	130276
AJK	13027603	name 278	20	130276
ISB-A	13027606	name 279	82	130276
ATK	13027607	name 280	1	130276
Gilgit-A	13027608	name 281	20	130276
RWP-B	13027609	name 282	81	130276
Gilgit-B	13027610	name 283	20	130276
RWP-A	13027611	name 284	20	130276
ISB-B	130283	name 285	31	130283
TAX	13028300	name 286	80	130283
RWP-C	13028302	name 287	20	130283
Chakwal	13028303	name 288	20	130283
AJK	13028305	name 289	21	130283
ISB-A	13028307	name 290	22	130283
ATK	13028308	name 291	30	130283
Gilgit-A	13028309	name 292	114	130283
RWP-B	13028310	name 293	20	130283
Gilgit-B	13028311	name 294	20	130283
RWP-A	13028312	name 295	20	130283
ISB-B	13028313	name 296	20	130283
TAX	13028315	name 297	20	130283
RWP-C	13028316	name 298	20	130283
Chakwal	13028317	name 299	20	130283
AJK	13028331	name 300	26	130283
ISB-A	130286	name 301	13	130286
ATK	13028600	name 302	81	130286
Gilgit-A	13028601	name 303	80	130286
RWP-B	13028602	name 304	2	130286
Gilgit-B	13028603	name 305	2	130286
RWP-A	13028605	name 306	2	130286
ISB-B	13028606	name 307	27	130286
TAX	13028609	name 308	2	130286
RWP-C	13028610	name 309	2	130286
Chakwal	130288	name 310	3	130288
AJK	13028800	name 311	81	130288
ISB-A	13028801	name 312	2	130288
ATK	13028802	name 313	5	130288
Gilgit-A	130293	name 314	9	130293
RWP-B	13029300	name 315	123	130293
Gilgit-B	13029301	name 316	26	130293
RWP-A	13029302	name 317	2	130293
ISB-B	13029306	name 318	2	130293
TAX	13029310	name 319	3	130293
RWP-C	13029313	name 320	15	130293
Chakwal	13029315	name 321	6	130293
AJK	13029316	name 322	34	130293
ISB-A	13029317	name 323	96	130293
ATK	13029318	name 324	28	130293
Gilgit-A	13029319	name 325	42	130293
RWP-B	13029323	name 326	1	130293
Gilgit-B	13029326	name 327	123	130293
RWP-A	13029330	name 328	65	130293
ISB-B	13029333	name 329	1	130293
TAX	13029337	name 330	49	130293
RWP-C	13029351	name 331	1	130293
Chakwal	13029353	name 332	2	130293
AJK	13029356	name 333	107	130293
ISB-A	13029358	name 334	2	130293
ATK	13029361	name 335	2	130293
Gilgit-A	13029362	name 336	55	130293
RWP-B	13029364	name 337	3	130293
Gilgit-B	13029367	name 338	107	130293
RWP-A	13029368	name 339	122	130293
ISB-B	13029369	name 340	45	130293
TAX	13029372	name 341	2	130293
RWP-C	13029373	name 342	4	130293
Chakwal	13029374	name 343	17	130293
AJK	13029376	name 344	9	130293
ISB-A	13029381	name 345	9	130293
ATK	13029387	name 346	23	130293
Gilgit-A	13029388	name 347	10	130293
RWP-B	13029389	name 348	1	130293
Gilgit-B	130294	name 349	98	130294
RWP-A	13029400	name 350	166	130294
ISB-B	13029402	name 351	83	130294
TAX	13029403	name 352	119	130294
RWP-C	13029404	name 353	2	130294
Chakwal	13029405	name 354	92	130294
AJK	13029410	name 355	1	130294
ISB-A	13029411	name 356	2	130294
ATK	13029412	name 357	4	130294
Gilgit-A	13029416	name 358	2	130294
RWP-B	13029418	name 359	102	130294
Gilgit-B	13029420	name 360	2	130294
RWP-A	13029421	name 361	100	130294
ISB-B	13029422	name 362	110	130294
TAX	13029423	name 363	85	130294
RWP-C	13029424	name 364	2	130294
Chakwal	13029425	name 365	82	130294
AJK	130295	name 366	1	130295
ISB-A	13029500	name 367	22	130295
ATK	13029501	name 368	9	130295
Gilgit-A	130296	name 369	1	130296
RWP-B	13029600	name 370	26	130296
Gilgit-B	13029604	name 371	24	130296
RWP-A	13029605	name 372	21	130296
ISB-B	13029606	name 373	21	130296
TAX	13029608	name 374	22	130296
RWP-C	13029609	name 375	21	130296
Chakwal	13029610	name 376	22	130296
AJK	13029613	name 377	3	130296
ISB-A	13029614	name 378	4	130296
ATK	13029615	name 379	21	130296
Gilgit-A	130297	name 380	1	130297
RWP-B	13029700	name 381	60	130297
Gilgit-B	13029800	name 382	4	130298
RWP-A	130301	name 383	5	130301
ISB-B	13030100	name 384	79	130301
TAX	13030101	name 385	60	130301
RWP-C	13030107	name 386	97	130301
Chakwal	13030110	name 387	20	130301
AJK	13030111	name 388	80	130301
ISB-A	13030112	name 389	80	130301
ATK	13030113	name 390	62	130301
Gilgit-A	13030114	name 391	20	130301
RWP-B	13030115	name 392	20	130301
Gilgit-B	13030116	name 393	9	130301
RWP-A	13030117	name 394	20	130301
ISB-B	13030118	name 395	2	130301
TAX	13030119	name 396	2	130301
RWP-C	13030121	name 397	2	130301
Chakwal	13030122	name 398	81	130301
AJK	13030124	name 399	2	130301
ISB-A	13030125	name 400	2	130301
ATK	13030126	name 401	80	130301
Gilgit-A	13030200	name 402	60	130302
RWP-B	13030201	name 403	20	130302
Gilgit-B	13030204	name 404	20	130302
RWP-A	130303	name 405	10	130303
ISB-B	130304	name 406	2	130304
TAX	13030400	name 407	79	130304
RWP-C	13030401	name 408	10	130304
Chakwal	13030402	name 409	23	130304
AJK	13030403	name 410	1	130304
ISB-A	13030404	name 411	22	130304
ATK	13030405	name 412	10	130304
Gilgit-A	130305	name 413	2	130305
RWP-B	13030500	name 414	94	130305
Gilgit-B	13030501	name 415	3	130305
RWP-A	13030502	name 416	3	130305
ISB-B	13030503	name 417	3	130305
TAX	13030800	name 418	71	130308
RWP-C	13030801	name 419	60	130308
Chakwal	13030802	name 420	6	130308
AJK	13030804	name 421	20	130308
ISB-A	13030806	name 422	13	130308
ATK	13030807	name 423	43	130308
Gilgit-A	13030808	name 424	4	130308
RWP-B	13030809	name 425	1	130308
Gilgit-B	13030811	name 426	10	130308
RWP-A	13030812	name 427	82	130308
ISB-B	13030813	name 428	10	130308
TAX	13030814	name 429	9	130308
RWP-C	13030816	name 430	22	130308
Chakwal	13030817	name 431	3	130308
AJK	130309	name 432	5	130309
ISB-A	13030900	name 433	80	130309
ATK	13030915	name 434	6	130309
Gilgit-A	13030916	name 435	80	130309
RWP-B	13030917	name 436	80	130309
Gilgit-B	13030918	name 437	35	130309
RWP-A	13030927	name 438	11	130309
ISB-B	13030928	name 439	51	130309
TAX	13030929	name 440	2	130309
RWP-C	13030930	name 441	29	130309
Chakwal	13030932	name 442	80	130309
AJK	13030933	name 443	80	130309
ISB-A	13030934	name 444	80	130309
ATK	13030935	name 445	2	130309
Gilgit-A	130310	name 446	5	130310
RWP-B	13031000	name 447	24	130310
Gilgit-B	13031001	name 448	20	130310
RWP-A	13031002	name 449	2	130310
ISB-B	13031003	name 450	80	130310
TAX	130312	name 451	2	130312
RWP-C	13031200	name 452	64	130312
Chakwal	13031201	name 453	6	130312
AJK	13031202	name 454	7	130312
ISB-A	13031203	name 455	60	130312
ATK	13031204	name 456	52	130312
Gilgit-A	13031206	name 457	8	130312
RWP-B	13031207	name 458	6	130312
Gilgit-B	130313	name 459	85	130313
RWP-A	13031400	name 460	40	130314
ISB-B	13031402	name 461	41	130314
TAX	13031403	name 462	28	130314
RWP-C	13031404	name 463	24	130314
Chakwal	13031405	name 464	44	130314
AJK	130317	name 465	24	130317
ISB-A	13031800	name 466	39	130318
ATK	13031801	name 467	2	130318
Gilgit-A	130319	name 468	26	130319
RWP-B	13031901	name 469	89	130319
Gilgit-B	13031904	name 470	80	130319
RWP-A	13031905	name 471	2	130319
ISB-B	13031906	name 472	2	130319
TAX	13031907	name 473	2	130319
RWP-C	13031908	name 474	2	130319
Chakwal	13031909	name 475	2	130319
AJK	13031910	name 476	80	130319
ISB-A	13031911	name 477	2	130319
ATK	13031913	name 478	2	130319
Gilgit-A	13031914	name 479	2	130319
RWP-B	130320	name 480	1	130320
Gilgit-B	130321	name 481	5	130321
RWP-A	13032100	name 482	82	130321
ISB-B	13032101	name 483	81	130321
TAX	13032102	name 484	43	130321
RWP-C	13032103	name 485	2	130321
Chakwal	13032107	name 486	3	130321
AJK	13032108	name 487	81	130321
ISB-A	13032400	name 488	80	130324
ATK	13032401	name 489	80	130324
Gilgit-A	13032402	name 490	1	130324
RWP-B	13032408	name 491	80	130324
Gilgit-B	13032409	name 492	3	130324
RWP-A	13032410	name 493	36	130324
ISB-B	130325	name 494	1	130325
TAX	13032500	name 495	80	130325
RWP-C	13032501	name 496	76	130325
Chakwal	13032502	name 497	80	130325
AJK	13032503	name 498	5	130325
ISB-A	13032504	name 499	2	130325
ATK	13032506	name 500	2	130325
Gilgit-A	13032508	name 501	80	130325
RWP-B	130326	name 502	2	130326
Gilgit-B	13032604	name 503	1	130326
RWP-A	13032605	name 504	1	130326
ISB-B	13032700	name 505	23	130327
TAX	13032800	name 506	80	130328
RWP-C	13032801	name 507	2	130328
Chakwal	13032802	name 508	2	130328
AJK	13032803	name 509	36	130328
ISB-A	13032804	name 510	2	130328
ATK	13032805	name 511	2	130328
Gilgit-A	130329	name 512	6	130329
RWP-B	13032900	name 513	80	130329
Gilgit-B	13032901	name 514	3	130329
RWP-A	13032902	name 515	60	130329
ISB-B	13032903	name 516	38	130329
TAX	13032904	name 517	2	130329
RWP-C	13032905	name 518	2	130329
Chakwal	13032906	name 519	2	130329
AJK	13032907	name 520	2	130329
ISB-A	13032908	name 521	2	130329
ATK	13033100	name 522	101	130331
Gilgit-A	13033101	name 523	131	130331
RWP-B	13033102	name 524	80	130331
Gilgit-B	13033104	name 525	80	130331
RWP-A	13033105	name 526	80	130331
ISB-B	13033106	name 527	80	130331
TAX	13033107	name 528	80	130331
RWP-C	13033108	name 529	80	130331
Chakwal	13033109	name 530	3	130331
AJK	13033110	name 531	16	130331
ISB-A	13033111	name 532	20	130331
ATK	13033112	name 533	20	130331
Gilgit-A	13033113	name 534	20	130331
RWP-B	13033114	name 535	20	130331
Gilgit-B	13033115	name 536	10	130331
RWP-A	13033116	name 537	2	130331
ISB-B	13033117	name 538	2	130331
TAX	13033118	name 539	2	130331
RWP-C	130333	name 540	7	130333
Chakwal	13033300	name 541	81	130333
AJK	13033301	name 542	88	130333
ISB-A	13033302	name 543	82	130333
ATK	13033304	name 544	85	130333
Gilgit-A	13033400	name 545	36	130334
RWP-B	13033401	name 546	81	130334
Gilgit-B	130335	name 547	50	130335
RWP-A	130336	name 548	7	130336
ISB-B	13033600	name 549	4	130336
TAX	13033601	name 550	3	130336
RWP-C	13033602	name 551	60	130336
Chakwal	13033603	name 552	2	130336
AJK	13033604	name 553	36	130336
ISB-A	13033605	name 554	2	130336
ATK	13033606	name 555	2	130336
Gilgit-A	13033607	name 556	82	130336
RWP-B	13033608	name 557	2	130336
Gilgit-B	13033609	name 558	80	130336
RWP-A	13033610	name 559	2	130336
ISB-B	13033611	name 560	2	130336
TAX	130337	name 561	4	130337
RWP-C	13033700	name 562	90	130337
Chakwal	13033701	name 563	2	130337
AJK	13033702	name 564	2	130337
ISB-A	13033703	name 565	2	130337
ATK	13033704	name 566	2	130337
Gilgit-A	13033705	name 567	80	130337
RWP-B	13033706	name 568	2	130337
Gilgit-B	13033707	name 569	2	130337
RWP-A	13033708	name 570	2	130337
ISB-B	13033709	name 571	2	130337
TAX	13033710	name 572	2	130337
RWP-C	13033711	name 573	82	130337
Chakwal	13033712	name 574	2	130337
AJK	13033713	name 575	2	130337
ISB-A	130339	name 576	70	130339
ATK	130341	name 577	5	130341
Gilgit-A	13034100	name 578	34	130341
RWP-B	130342	name 579	2	130342
Gilgit-B	13034200	name 580	62	130342
RWP-A	13034201	name 581	2	130342
ISB-B	13034202	name 582	2	130342
TAX	13034203	name 583	2	130342
RWP-C	13034204	name 584	2	130342
Chakwal	130343	name 585	2	130343
AJK	13034300	name 586	47	130343
ISB-A	13034400	name 587	77	130344
ATK	130345	name 588	60	130345
Gilgit-A	130346	name 589	1	130346
RWP-B	13034600	name 590	7	130346
Gilgit-B	13034601	name 591	2	130346
RWP-A	13034602	name 592	4	130346
ISB-B	13034603	name 593	2	130346
TAX	13034604	name 594	2	130346
RWP-C	13034605	name 595	2	130346
Chakwal	130347	name 596	109	130347

 

[earthworm]

As per my understanding you need to add all sales >30

Try this

=SUMIF(D2:D597,">"&30,D2:D597)

 

[Muhammad_Usman]

Hy Faizan.

I think Pivot table is best solution for your problem!

09-09-21.xlsx
	G	H	I
1	Wholesaler	dealers	Sum of sales
2	130001		221
3	130001	13000100	82
4	130001	13000102	59
5	130001	13000108	80
6	130002		746
7	130002	13000200	79
8	130002	13000207	100
9	130002	13000209	104
10	130002	13000212	87
11	130002	13000225	80
12	130002	13000233	80
13	130002	13000234	35
14	130002	13000247	80
15	130002	13000263	101
16	130003		105
17	130003	13000300	105
18	130015		269
19	130015	13001500	66
20	130015	13001511	52
21	130015	13001519	74
22	130015	13001558	77
23	130034		80
24	130034	13003400	80
25	130048		1337
26	130048	13004800	81
27	130048	13004802	80
28	130048	13004808	81
29	130048	13004811	80
30	130048	13004831	80
31	130048	13004849	80
32	130048	13004889	82
33	130048	13004891	80
34	130048	13004894	80
35	130048	13004897	80
36	130048	130048100	51
37	130048	130048101	76
38	130048	130048102	80
39	130048	130048103	80
40	130048	130048106	82
41	130048	130048107	80
42	130048	130048108	84
43	130051		567
44	130051	13005100	81
45	130051	13005101	80
46	130051	13005103	80
47	130051	13005106	82
48	130051	13005110	84
49	130051	13005142	80
50	130051	13005164	80
51	130075		207
52	130075	13007500	207
53	130081		298
54	130081	13008100	64
55	130081	13008104	74
56	130081	13008114	80
57	130081	13008133	80
58	130093		82
59	130093	130093	82
60	130096		796
61	130096	13009600	81
62	130096	13009604	80
63	130096	13009617	80
64	130096	13009625	80
65	130096	13009661	80
66	130096	13009669	80
67	130096	13009680	80
68	130096	13009681	80
69	130096	13009682	75
70	130096	130096106	80
71	130190		89
72	130190	13019000	89
73	130210		179
74	130210	13021022	98
75	130210	13021044	81
76	130233		537
77	130233	13023300	152
78	130233	13023301	80
79	130233	13023303	81
80	130233	13023307	82
81	130233	13023310	82
82	130233	13023311	60
83	130244		121
84	130244	13024400	81
85	130244	13024419	40
86	130256		80
87	130256	13025600	80
88	130265		361
89	130265	13026500	82
90	130265	13026502	80
91	130265	13026503	80
92	130265	13026504	80
93	130265	13026517	39
94	130268		40
95	130268	13026800	40
96	130272		709
97	130272	13027200	81
98	130272	13027204	80
99	130272	13027206	80
100	130272	13027207	148
101	130272	13027209	80
102	130272	13027212	80
103	130272	13027220	80
104	130272	13027222	80
105	130276		245
106	130276	13027600	82
107	130276	13027606	82
108	130276	13027609	81
109	130283		225
110	130283	130283	31
111	130283	13028300	80
112	130283	13028309	114
113	130286		161
114	130286	13028600	81
115	130286	13028601	80
116	130288		81
117	130288	13028800	81
118	130293		968
119	130293	13029300	123
120	130293	13029316	34
121	130293	13029317	96
122	130293	13029319	42
123	130293	13029326	123
124	130293	13029330	65
125	130293	13029337	49
126	130293	13029356	107
127	130293	13029362	55
128	130293	13029367	107
129	130293	13029368	122
130	130293	13029369	45
131	130294		1037
132	130294	130294	98
133	130294	13029400	166
134	130294	13029402	83
135	130294	13029403	119
136	130294	13029405	92
137	130294	13029418	102
138	130294	13029421	100
139	130294	13029422	110
140	130294	13029423	85
141	130294	13029425	82
142	130297		60
143	130297	13029700	60
144	130301		619
145	130301	13030100	79
146	130301	13030101	60
147	130301	13030107	97
148	130301	13030111	80
149	130301	13030112	80
150	130301	13030113	62
151	130301	13030122	81
152	130301	13030126	80
153	130302		60
154	130302	13030200	60
155	130304		79
156	130304	13030400	79
157	130305		94
158	130305	13030500	94
159	130308		256
160	130308	13030800	71
161	130308	13030801	60
162	130308	13030807	43
163	130308	13030812	82
164	130309		566
165	130309	13030900	80
166	130309	13030916	80
167	130309	13030917	80
168	130309	13030918	35
169	130309	13030928	51
170	130309	13030932	80
171	130309	13030933	80
172	130309	13030934	80
173	130310		80
174	130310	13031003	80
175	130312		176
176	130312	13031200	64
177	130312	13031203	60
178	130312	13031204	52
179	130313		85
180	130313	130313	85
181	130314		125
182	130314	13031400	40
183	130314	13031402	41
184	130314	13031405	44
185	130318		39
186	130318	13031800	39
187	130319		249
188	130319	13031901	89
189	130319	13031904	80
190	130319	13031910	80
191	130321		287
192	130321	13032100	82
193	130321	13032101	81
194	130321	13032102	43
195	130321	13032108	81
196	130324		276
197	130324	13032400	80
198	130324	13032401	80
199	130324	13032408	80
200	130324	13032410	36
201	130325		316
202	130325	13032500	80
203	130325	13032501	76
204	130325	13032502	80
205	130325	13032508	80
206	130328		116
207	130328	13032800	80
208	130328	13032803	36
209	130329		178
210	130329	13032900	80
211	130329	13032902	60
212	130329	13032903	38
213	130331		712
214	130331	13033100	101
215	130331	13033101	131
216	130331	13033102	80
217	130331	13033104	80
218	130331	13033105	80
219	130331	13033106	80
220	130331	13033107	80
221	130331	13033108	80
222	130333		336
223	130333	13033300	81
224	130333	13033301	88
225	130333	13033302	82
226	130333	13033304	85
227	130334		117
228	130334	13033400	36
229	130334	13033401	81
230	130335		50
231	130335	130335	50
232	130336		258
233	130336	13033602	60
234	130336	13033604	36
235	130336	13033607	82
236	130336	13033609	80
237	130337		252
238	130337	13033700	90
239	130337	13033705	80
240	130337	13033711	82
241	130339		70
242	130339	130339	70
243	130341		34
244	130341	13034100	34
245	130342		62
246	130342	13034200	62
247	130343		47
248	130343	13034300	47
249	130344		77
250	130344	13034400	77
251	130345		60
252	130345	130345	60
253	130347		109
254	130347	130347	109
255	Grand Total		15386
Sheet2

09-09-21.xlsx
	G	H
1	Wholesaler	Sum of sales
2	130001	224
3	130002	764
4	130003	105
5	130015	297
6	130034	91
7	130048	1417
8	130051	683
9	130075	210
10	130081	325
11	130093	82
12	130096	1033
13	130190	100
14	130191	39
15	130210	256
16	130233	556
17	130244	134
18	130256	97
19	130265	522
20	130268	63
21	130272	831
22	130276	348
23	130283	504
24	130286	211
25	130288	91
26	130293	1146
27	130294	1052
28	130295	32
29	130296	186
30	130297	61
31	130301	723
32	130302	100
33	130304	147
34	130305	105
35	130308	354
36	130309	621
37	130310	131
38	130312	205
39	130313	85
40	130314	177
41	130318	41
42	130319	291
43	130321	297
44	130324	280
45	130325	326
46	130328	124
47	130329	197
48	130331	827
49	130333	343
50	130334	117
51	130335	50
52	130336	284
53	130337	278
54	130339	70
55	130341	39
56	130342	72
57	130343	49
58	130344	77
59	130345	60
60	130347	109
61	Grand Total	18039
Sheet2

 

[faizan1132]

As per my understanding you need to add all sales >30

Try this

=SUMIF(D2:D597,">"&30,D2:D597)

No no i need to add sales which are under same wholesaler which are greater than 30.

 

[faizan1132]

Hy Faizan.

I think Pivot table is best solution for your problem!

09-09-21.xlsx
	G	H	I
1	Wholesaler	dealers	Sum of sales
2	130001		221
3	130001	13000100	82
4	130001	13000102	59
5	130001	13000108	80
6	130002		746
7	130002	13000200	79
8	130002	13000207	100
9	130002	13000209	104
10	130002	13000212	87
11	130002	13000225	80
12	130002	13000233	80
13	130002	13000234	35
14	130002	13000247	80
15	130002	13000263	101
16	130003		105
17	130003	13000300	105
18	130015		269
19	130015	13001500	66
20	130015	13001511	52
21	130015	13001519	74
22	130015	13001558	77
23	130034		80
24	130034	13003400	80
25	130048		1337
26	130048	13004800	81
27	130048	13004802	80
28	130048	13004808	81
29	130048	13004811	80
30	130048	13004831	80
31	130048	13004849	80
32	130048	13004889	82
33	130048	13004891	80
34	130048	13004894	80
35	130048	13004897	80
36	130048	130048100	51
37	130048	130048101	76
38	130048	130048102	80
39	130048	130048103	80
40	130048	130048106	82
41	130048	130048107	80
42	130048	130048108	84
43	130051		567
44	130051	13005100	81
45	130051	13005101	80
46	130051	13005103	80
47	130051	13005106	82
48	130051	13005110	84
49	130051	13005142	80
50	130051	13005164	80
51	130075		207
52	130075	13007500	207
53	130081		298
54	130081	13008100	64
55	130081	13008104	74
56	130081	13008114	80
57	130081	13008133	80
58	130093		82
59	130093	130093	82
60	130096		796
61	130096	13009600	81
62	130096	13009604	80
63	130096	13009617	80
64	130096	13009625	80
65	130096	13009661	80
66	130096	13009669	80
67	130096	13009680	80
68	130096	13009681	80
69	130096	13009682	75
70	130096	130096106	80
71	130190		89
72	130190	13019000	89
73	130210		179
74	130210	13021022	98
75	130210	13021044	81
76	130233		537
77	130233	13023300	152
78	130233	13023301	80
79	130233	13023303	81
80	130233	13023307	82
81	130233	13023310	82
82	130233	13023311	60
83	130244		121
84	130244	13024400	81
85	130244	13024419	40
86	130256		80
87	130256	13025600	80
88	130265		361
89	130265	13026500	82
90	130265	13026502	80
91	130265	13026503	80
92	130265	13026504	80
93	130265	13026517	39
94	130268		40
95	130268	13026800	40
96	130272		709
97	130272	13027200	81
98	130272	13027204	80
99	130272	13027206	80
100	130272	13027207	148
101	130272	13027209	80
102	130272	13027212	80
103	130272	13027220	80
104	130272	13027222	80
105	130276		245
106	130276	13027600	82
107	130276	13027606	82
108	130276	13027609	81
109	130283		225
110	130283	130283	31
111	130283	13028300	80
112	130283	13028309	114
113	130286		161
114	130286	13028600	81
115	130286	13028601	80
116	130288		81
117	130288	13028800	81
118	130293		968
119	130293	13029300	123
120	130293	13029316	34
121	130293	13029317	96
122	130293	13029319	42
123	130293	13029326	123
124	130293	13029330	65
125	130293	13029337	49
126	130293	13029356	107
127	130293	13029362	55
128	130293	13029367	107
129	130293	13029368	122
130	130293	13029369	45
131	130294		1037
132	130294	130294	98
133	130294	13029400	166
134	130294	13029402	83
135	130294	13029403	119
136	130294	13029405	92
137	130294	13029418	102
138	130294	13029421	100
139	130294	13029422	110
140	130294	13029423	85
141	130294	13029425	82
142	130297		60
143	130297	13029700	60
144	130301		619
145	130301	13030100	79
146	130301	13030101	60
147	130301	13030107	97
148	130301	13030111	80
149	130301	13030112	80
150	130301	13030113	62
151	130301	13030122	81
152	130301	13030126	80
153	130302		60
154	130302	13030200	60
155	130304		79
156	130304	13030400	79
157	130305		94
158	130305	13030500	94
159	130308		256
160	130308	13030800	71
161	130308	13030801	60
162	130308	13030807	43
163	130308	13030812	82
164	130309		566
165	130309	13030900	80
166	130309	13030916	80
167	130309	13030917	80
168	130309	13030918	35
169	130309	13030928	51
170	130309	13030932	80
171	130309	13030933	80
172	130309	13030934	80
173	130310		80
174	130310	13031003	80
175	130312		176
176	130312	13031200	64
177	130312	13031203	60
178	130312	13031204	52
179	130313		85
180	130313	130313	85
181	130314		125
182	130314	13031400	40
183	130314	13031402	41
184	130314	13031405	44
185	130318		39
186	130318	13031800	39
187	130319		249
188	130319	13031901	89
189	130319	13031904	80
190	130319	13031910	80
191	130321		287
192	130321	13032100	82
193	130321	13032101	81
194	130321	13032102	43
195	130321	13032108	81
196	130324		276
197	130324	13032400	80
198	130324	13032401	80
199	130324	13032408	80
200	130324	13032410	36
201	130325		316
202	130325	13032500	80
203	130325	13032501	76
204	130325	13032502	80
205	130325	13032508	80
206	130328		116
207	130328	13032800	80
208	130328	13032803	36
209	130329		178
210	130329	13032900	80
211	130329	13032902	60
212	130329	13032903	38
213	130331		712
214	130331	13033100	101
215	130331	13033101	131
216	130331	13033102	80
217	130331	13033104	80
218	130331	13033105	80
219	130331	13033106	80
220	130331	13033107	80
221	130331	13033108	80
222	130333		336
223	130333	13033300	81
224	130333	13033301	88
225	130333	13033302	82
226	130333	13033304	85
227	130334		117
228	130334	13033400	36
229	130334	13033401	81
230	130335		50
231	130335	130335	50
232	130336		258
233	130336	13033602	60
234	130336	13033604	36
235	130336	13033607	82
236	130336	13033609	80
237	130337		252
238	130337	13033700	90
239	130337	13033705	80
240	130337	13033711	82
241	130339		70
242	130339	130339	70
243	130341		34
244	130341	13034100	34
245	130342		62
246	130342	13034200	62
247	130343		47
248	130343	13034300	47
249	130344		77
250	130344	13034400	77
251	130345		60
252	130345	130345	60
253	130347		109
254	130347	130347	109
255	Grand Total		15386
Sheet2

09-09-21.xlsx
	G	H
1	Wholesaler	Sum of sales
2	130001	224
3	130002	764
4	130003	105
5	130015	297
6	130034	91
7	130048	1417
8	130051	683
9	130075	210
10	130081	325
11	130093	82
12	130096	1033
13	130190	100
14	130191	39
15	130210	256
16	130233	556
17	130244	134
18	130256	97
19	130265	522
20	130268	63
21	130272	831
22	130276	348
23	130283	504
24	130286	211
25	130288	91
26	130293	1146
27	130294	1052
28	130295	32
29	130296	186
30	130297	61
31	130301	723
32	130302	100
33	130304	147
34	130305	105
35	130308	354
36	130309	621
37	130310	131
38	130312	205
39	130313	85
40	130314	177
41	130318	41
42	130319	291
43	130321	297
44	130324	280
45	130325	326
46	130328	124
47	130329	197
48	130331	827
49	130333	343
50	130334	117
51	130335	50
52	130336	284
53	130337	278
54	130339	70
55	130341	39
56	130342	72
57	130343	49
58	130344	77
59	130345	60
60	130347	109
61	Grand Total	18039
Sheet2

Your solution is right but i need to do it with formulae actually.. Sumifs or some other.

 

[earthworm]

Add below formula at end of Whole sale

=SUMIF($F$2:$F$597,TRUE,D2:D597)

and add below formula in front of wholesale and drag it down.

=COUNTIF($E$2:$E$597,E2)>30

 

[Muhammad_Usman]

Your solution is right but i need to do it with formulae actually.. Sumifs or some other.

Glad to help you.

Yes You can do it with Formula,

Just copy and paste wholesaler to another column and remove duplicate.

Then apply formula mention below.

Feel free if there is any problem.!

Book1.xlsm
	J	K
1	Wholesaler	Sum >30
2	130001	221
3	130002	746
4	130003	105
5	130015	269
6	130034	80
7	130048	1337
8	130051	567
9	130075	207
10	130081	298
11	130093	82
12	130096	796
13	130190	89
14	130191	0
15	130210	179
16	130233	537
17	130244	121
18	130256	80
19	130265	361
20	130268	40
21	130272	709
22	130276	245
23	130283	225
24	130286	161
25	130288	81
26	130293	968
27	130294	1037
28	130295	0
29	130296	0
30	130297	60
31	130301	619
32	130302	60
33	130304	79
34	130305	94
35	130308	256
36	130309	566
37	130310	80
38	130312	176
39	130313	85
40	130314	125
41	130318	39
42	130319	249
43	130321	287
44	130324	276
45	130325	316
46	130328	116
47	130329	178
48	130331	712
49	130333	336
50	130334	117
51	130335	50
52	130336	258
53	130337	252
54	130339	70
55	130341	34
56	130342	62
57	130343	47
58	130344	77
59	130345	60
60	130347	109
61	Grand Total	15386
sht

Cell Formulas
Range	Formula
K2:K60	K2	=SUMIFS($D$2:$D$597,$E$2:$E$597,J2,$D$2:$D$597,">"&30)
K61	K61	=SUM(K2:K60)

 

[faizan1132]

Th

Glad to help you.

Yes You can do it with Formula,

Just copy and paste wholesaler to another column and remove duplicate.

Then apply formula mention below.

Feel free if there is any problem.!

Book1.xlsm
	J	K
1	Wholesaler	Sum >30
2	130001	221
3	130002	746
4	130003	105
5	130015	269
6	130034	80
7	130048	1337
8	130051	567
9	130075	207
10	130081	298
11	130093	82
12	130096	796
13	130190	89
14	130191	0
15	130210	179
16	130233	537
17	130244	121
18	130256	80
19	130265	361
20	130268	40
21	130272	709
22	130276	245
23	130283	225
24	130286	161
25	130288	81
26	130293	968
27	130294	1037
28	130295	0
29	130296	0
30	130297	60
31	130301	619
32	130302	60
33	130304	79
34	130305	94
35	130308	256
36	130309	566
37	130310	80
38	130312	176
39	130313	85
40	130314	125
41	130318	39
42	130319	249
43	130321	287
44	130324	276
45	130325	316
46	130328	116
47	130329	178
48	130331	712
49	130333	336
50	130334	117
51	130335	50
52	130336	258
53	130337	252
54	130339	70
55	130341	34
56	130342	62
57	130343	47
58	130344	77
59	130345	60
60	130347	109
61	Grand Total	15386
sht

Cell Formulas
Range	Formula
K2:K60	K2	=SUMIFS($D$2:$D$597,$E$2:$E$597,J2,$D$2:$D$597,">"&30)
K61	K61	=SUM(K2:K60)

T

Thank You so much means alot..

 

[Muhammad_Usman]

Th

Thank You so much means alot..

Always Welcome