Hello. I am new on this post. I am trying to summary this sheet by well and by month including a data validation so I can toggle between the type of product ( Oil or Gas).
Can anybody help me building this summary table? Thanks.
Can anybody help me building this summary table? Thanks.
Production Month | Product | Seifert C 1H | Smolik A 1H | Greaves A 1H | Greaves A 2H | Greaves B 1H | Greaves B 2H | Greaves B 3H | Greaves B 4H | Greaves B 5H | Greaves B 6H | Banduch 1H | Moczygemba 1H | Golden B 2H | Golden B 4H | Golden B 6H | Golden B 8H | Golden B 10H | KC 3H | KC 4H |
Aug-11 | Oil | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Sep-11 | Oil | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Oct-11 | Oil | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Nov-11 | Oil | 16,994 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Dec-11 | Oil | 30,412 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Jan-12 | Oil | 19,443 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Feb-12 | Oil | 25,398 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Mar-12 | Oil | 24,498 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Apr-12 | Oil | 22,067 | - | 857 | - | 1,087 | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
May-12 | Oil | 22,401 | - | 1,230 | - | 1,481 | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Jun-12 | Oil | 20,035 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Jul-12 | Oil | 21,042 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Aug-12 | Oil | 20,639 | 3,905 | - | 4,444 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Sep-12 | Oil | 17,400 | 14,764 | - | 15,602 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Oct-12 | Oil | 13,562 | 19,588 | 20,918 | 16,808 | 17,483 | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Nov-12 | Oil | 13,609 | 20,147 | 26,937 | 13,036 | 21,135 | - | - | - | - | - | 3,950 | - | - | - | - | - | - | - | - |
Dec-12 | Oil | 14,759 | 25,437 | 22,664 | 22,090 | 18,927 | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Jan-13 | Oil | 14,645 | 19,363 | 17,708 | 18,200 | 18,663 | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Feb-13 | Oil | 11,098 | 14,095 | 15,391 | 12,789 | 14,533 | - | - | - | - | - | 9,988 | - | - | - | - | - | - | - | - |
Mar-13 | Oil | 8,259 | 19,599 | 20,319 | 11,518 | 7,437 | - | - | - | - | - | 12,184 | - | - | - | - | - | - | - | - |
Apr-13 | Oil | 7,622 | 14,667 | 17,087 | 7,994 | - | - | 6,127 | - | 3,150 | - | 11,197 | - | - | - | - | - | - | - | - |
May-13 | Oil | 7,041 | 11,197 | 14,005 | 9,051 | - | - | 15,336 | - | 9,839 | - | 10,581 | 11,428 | - | - | 38,427 | 44,474 | 45,442 | - | - |
Jun-13 | Oil | 6,806 | 7,907 | 9,974 | 2,735 | - | - | 29,356 | - | 30,578 | - | 9,005 | 13,764 | - | - | 13,547 | 13,734 | 13,888 | - | - |
Jul-13 | Oil | 6,537 | 7,210 | 3,020 | 3,648 | - | - | 11,446 | - | 45,251 | - | 8,719 | 12,346 | 23,310 | - | 28,826 | 26,143 | 26,084 | 10,016 | 7,663 |
Aug-13 | Oil | 5,695 | 8,407 | 5,987 | 6,332 | - | 7,872 | 10,020 | 7,363 | 40,331 | 7,655 | 8,505 | 10,593 | 26,327 | - | 29,534 | 26,231 | 26,927 | 22,069 | 18,003 |
Sep-13 | Oil | 5,872 | 3,516 | 5,472 | - | - | 21,404 | 16,139 | 21,672 | 24,896 | 20,564 | 7,448 | 8,598 | 22,442 | - | 23,426 | 20,737 | 21,202 | 17,504 | 14,049 |
Oct-13 | Oil | 4,701 | - | 4,729 | - | - | 17,938 | 21,558 | 16,806 | 16,664 | 16,499 | 7,371 | 8,282 | 15,573 | 1,694 | 20,399 | 17,821 | 18,712 | 16,059 | 11,091 |
Nov-13 | Oil | - | 6,488 | 4,345 | 7,789 | - | 9,226 | 21,251 | 12,726 | 11,579 | 12,073 | 6,484 | 6,535 | 11,391 | 1,019 | 15,154 | 13,024 | 14,563 | 14,627 | 12,748 |
Dec-13 | Oil | - | 790 | 2,554 | 2,317 | - | 10,879 | 19,507 | 8,286 | 8,914 | 6,910 | 5,566 | 7,860 | 14,575 | 941 | 18,090 | 15,834 | 16,961 | 15,706 | 13,371 |
Jan-14 | Oil | - | 3,073 | 3,386 | 3,516 | - | 8,330 | 16,682 | 3,499 | 7,425 | 4,225 | 5,503 | 7,904 | 8,367 | 1,074 | 9,222 | 10,076 | 17,839 | 12,511 | 4,449 |
Feb-14 | Oil | - | 4,322 | 1,228 | 5,288 | - | 1,131 | 10,256 | 1,388 | 7,002 | 4,156 | 5,454 | 7,113 | 11,625 | 1,176 | 10,650 | 6,629 | 15,681 | 9,103 | 3,412 |
Mar-14 | Oil | - | 1,630 | 1,505 | - | - | 2,064 | 9,248 | 4,471 | 1,637 | 1,571 | 9,784 | 7,853 | 10,264 | 1,098 | 12,154 | 7,773 | 12,339 | 9,656 | 6,253 |
Apr-14 | Oil | 1,930 | 10,769 | 1 | 1,610 | - | 2,249 | 7,770 | 4,317 | 6,309 | 2,366 | 4,993 | 6,372 | 13,911 | 1,028 | 13,569 | 10,059 | 13,302 | 8,316 | 5,145 |
May-14 | Oil | 3,315 | 8,044 | - | 1,225 | - | 1,825 | 5,788 | 1,649 | 5,579 | 1,756 | 3,848 | 6,238 | 13,428 | 775 | 10,544 | 6,433 | 11,562 | - | - |
Jun-14 | Oil | 263 | - | - | - | - | - | - | - | - | - | - | - | 487 | 23 | 417 | 201 | 348 | - | - |
Jul-14 | Oil | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Aug-14 | Oil | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Sep-14 | Oil | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Oct-14 | Oil | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Nov-14 | Oil | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Dec-14 | Oil | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Aug-11 | Gas | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Sep-11 | Gas | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Oct-11 | Gas | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Nov-11 | Gas | 31,577 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Dec-11 | Gas | 56,633 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Jan-12 | Gas | 41,818 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Feb-12 | Gas | 55,240 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Mar-12 | Gas | 56,594 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Apr-12 | Gas | 50,805 | - | 1,590 | - | 1,044 | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
May-12 | Gas | 52,360 | - | 1,574 | - | 1,402 | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Jun-12 | Gas | 46,905 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Jul-12 | Gas | 44,472 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Aug-12 | Gas | 45,926 | 3,210 | - | 3,733 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Sep-12 | Gas | 41,029 | 14,870 | - | 14,484 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Oct-12 | Gas | 33,616 | 21,335 | 21,479 | 18,511 | 13,953 | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Nov-12 | Gas | 33,213 | 493 | 543 | 416 | 466 | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Dec-12 | Gas | 34,551 | 29,110 | 25,321 | 27,774 | 16,532 | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Jan-13 | Gas | 33,104 | 30,121 | 27,797 | 30,568 | 19,353 | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Feb-13 | Gas | 26,963 | 19,106 | 21,496 | 18,109 | 13,237 | - | - | - | - | - | 3,615 | - | - | - | - | - | - | - | - |
Mar-13 | Gas | 21,206 | 27,141 | 24,740 | 16,144 | 7,484 | - | - | - | - | - | 9,938 | - | - | - | - | - | - | - | - |
Apr-13 | Gas | 18,146 | 19,635 | 22,798 | 12,855 | - | - | 4,256 | - | 1,885 | - | 13,491 | - | - | - | - | - | - | - | - |
May-13 | Gas | 16,883 | 14,543 | 18,551 | 14,246 | - | - | 11,977 | - | 6,811 | - | 11,469 | 7,026 | - | - | 39,213 | 43,260 | 42,688 | - | - |
Jun-13 | Gas | 16,386 | 9,408 | 13,515 | 3,788 | - | - | 27,268 | - | 29,107 | - | 8,927 | 16,591 | - | - | 39,609 | 35,297 | 36,850 | - | - |
Jul-13 | Gas | 16,368 | 9,170 | 4,302 | 3,887 | - | - | 14,965 | - | 45,091 | - | 11,651 | 16,321 | 21,728 | - | 29,312 | 25,643 | 26,163 | 10,462 | 7,674 |
Aug-13 | Gas | 15,408 | 11,433 | 6,009 | 9,194 | - | 7,140 | 13,134 | 7,488 | 37,422 | 6,588 | 12,217 | 16,057 | 29,414 | - | 35,008 | 30,836 | 31,640 | 24,287 | 20,961 |
Sep-13 | Gas | 14,449 | 4,303 | 6,219 | - | - | 22,491 | 11,917 | 22,944 | 27,409 | 21,801 | 11,087 | 12,459 | 26,598 | - | 28,011 | 24,116 | 24,558 | 7,031 | 5,117 |
Oct-13 | Gas | 10,264 | - | 5,756 | - | - | 17,508 | 14,840 | 17,474 | 20,030 | 16,820 | 10,904 | 12,191 | 17,103 | 948 | 23,863 | 20,686 | 21,354 | 16,603 | 11,717 |
Nov-13 | Gas | - | 8,544 | 4,725 | 9,098 | - | 7,330 | 15,769 | 12,113 | 14,351 | 11,829 | 6,750 | 7,790 | 11,499 | 502 | 14,481 | 13,610 | 13,951 | 14,857 | 13,912 |
Dec-13 | Gas | - | 580 | 2,233 | 2,089 | - | 8,466 | 13,299 | 8,356 | 12,897 | 8,846 | 5,724 | 8,311 | 11,398 | 221 | 16,045 | 14,387 | 18,278 | 16,946 | 12,086 |
Jan-14 | Gas | - | 3,318 | 3,524 | 4,306 | - | 8,592 | 13,248 | 3,922 | 9,236 | 5,762 | 2,989 | 4,363 | 7,667 | 333 | 9,423 | 9,884 | 20,061 | 11,113 | 4,739 |
Feb-14 | Gas | - | 4,698 | 1,147 | 6,458 | - | 746 | 6,968 | 2,014 | 6,335 | 2,843 | 4,501 | 5,406 | 12,125 | 445 | 12,080 | 7,791 | 20,529 | 7,841 | 3,185 |
Mar-14 | Gas | - | 2,049 | 1,370 | - | - | 856 | 7,198 | 4,363 | 2,184 | 795 | 10,124 | 8,668 | 10,036 | 1,431 | 13,294 | 8,463 | 15,192 | 8,500 | 5,735 |
Apr-14 | Gas | 4,817 | 13,606 | - | 1,499 | 1 | 2,082 | 9,469 | 4,831 | 4,717 | 1,051 | 3,983 | 7,039 | 8,021 | 1,697 | 16,614 | 12,329 | 17,861 | 7,134 | 4,178 |
May-14 | Gas | 6,845 | 8,953 | - | 1,260 | 0 | 1,330 | 5,395 | 1,418 | 4,845 | 822 | 3,254 | 6,586 | 10,874 | 813 | 12,923 | 10,842 | 14,727 | - | - |
Jun-14 | Gas | 286 | - | - | - | - | - | - | - | - | - | - | - | 582 | - | 512 | 249 | 411 | - | - |
Jul-14 | Gas | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Aug-14 | Gas | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Sep-14 | Gas | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Oct-14 | Gas | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Nov-14 | Gas | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Dec-14 | Gas | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Oil | Jan-13 | Feb-13 | Mar-13 | Apr-13 | May-13 | Jun-13 | Jul-13 | Aug-13 | Sep-13 | Oct-13 | Nov-13 | Dec-13 | Total | |||||||
Banduch 1H | 0 | |||||||||||||||||||
Golden B 10H | 0 | |||||||||||||||||||
Golden B 2H | 0 | |||||||||||||||||||
Golden B 4H | 0 | |||||||||||||||||||
Golden B 6H | 0 | |||||||||||||||||||
Golden B 8H | 0 | |||||||||||||||||||
Greaves A 1H | 0 | |||||||||||||||||||
Greaves A 2H | 0 | |||||||||||||||||||
Greaves B 1H | 0 | |||||||||||||||||||
Greaves B 2H | 0 | |||||||||||||||||||
Greaves B 3H | 0 | |||||||||||||||||||
Greaves B 4H | 0 | |||||||||||||||||||
Greaves B 5H | 0 | |||||||||||||||||||
Greaves B 6H | 0 | |||||||||||||||||||
KC 3H | 0 | |||||||||||||||||||
KC 4H | 0 | |||||||||||||||||||
Moczygemba 1H | 0 | |||||||||||||||||||
Seifert C 1H | 0 | |||||||||||||||||||
Smolik A 1H | 0 | |||||||||||||||||||
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||