JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
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 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
Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
As per my understanding you need to add all sales >30
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
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
As per my understanding you need to add all sales >30
No no i need to add sales which are under same wholesaler which are greater than 30.
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
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
Your solution is right but i need to do it with formulae actually.. Sumifs or some other.
Add below formula at end of Whole sale
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.!
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.!
T
Thank You so much means alot..
Th
Always Welcome
Threads
1,223,888
Messages
6,175,205
Members
452,618
Latest member
Tam84
