Help with Index, Match & sum

jazzista

Board Regular
Joined
Sep 15, 2014
Messages
86
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.

Production MonthProductSeifert C 1HSmolik A 1HGreaves A 1HGreaves A 2HGreaves B 1HGreaves B 2HGreaves B 3HGreaves B 4HGreaves B 5HGreaves B 6HBanduch 1HMoczygemba 1HGolden B 2HGolden B 4HGolden B 6HGolden B 8HGolden B 10HKC 3HKC 4H
Aug-11Oil
-------------------
Sep-11Oil-------------------
Oct-11Oil-------------------
Nov-11Oil16,994 ------------------
Dec-11Oil30,412 ------------------
Jan-12Oil19,443 ------------------
Feb-12Oil25,398 ------------------
Mar-12Oil24,498 ------------------
Apr-12Oil22,067 -857 -1,087 --------------
May-12Oil22,401 -1,230 -1,481 --------------
Jun-12Oil20,035 ------------------
Jul-12Oil21,042 ------------------
Aug-12Oil20,639 3,905 -4,444 ---------------
Sep-12Oil17,400 14,764 -15,602 ---------------
Oct-12Oil13,562 19,588 20,918 16,808 17,483 --------------
Nov-12Oil13,609 20,147 26,937 13,036 21,135 -----3,950 --------
Dec-12Oil14,759 25,437 22,664 22,090 18,927 --------------
Jan-13Oil14,645 19,363 17,708 18,200 18,663 --------------
Feb-13Oil11,098 14,095 15,391 12,789 14,533 -----9,988 --------
Mar-13Oil8,259 19,599 20,319 11,518 7,437 -----12,184 --------
Apr-13Oil7,622 14,667 17,087 7,994 --6,127 -3,150 -11,197 --------
May-13Oil7,041 11,197 14,005 9,051 --15,336 -9,839 -10,581 11,428 --38,427 44,474 45,442 --
Jun-13Oil6,806 7,907 9,974 2,735 --29,356 -30,578 -9,005 13,764 --13,547 13,734 13,888 --
Jul-13Oil6,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-13Oil5,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-13Oil5,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-13Oil4,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-13Oil-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-13Oil-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-14Oil-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-14Oil-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-14Oil-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-14Oil1,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-14Oil3,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-14Oil263 -----------487 23 417 201 348 --
Jul-14Oil-------------------
Aug-14Oil-------------------
Sep-14Oil-------------------
Oct-14Oil-------------------
Nov-14Oil-------------------
Dec-14Oil-------------------
Aug-11Gas-------------------
Sep-11Gas-------------------
Oct-11Gas-------------------
Nov-11Gas31,577 ------------------
Dec-11Gas56,633 ------------------
Jan-12Gas41,818 ------------------
Feb-12Gas55,240 ------------------
Mar-12Gas56,594 ------------------
Apr-12Gas50,805 -1,590 -1,044 --------------
May-12Gas52,360 -1,574 -1,402 --------------
Jun-12Gas46,905 ------------------
Jul-12Gas44,472 ------------------
Aug-12Gas45,926 3,210 -3,733 ---------------
Sep-12Gas41,029 14,870 -14,484 ---------------
Oct-12Gas33,616 21,335 21,479 18,511 13,953 --------------
Nov-12Gas33,213 493 543 416 466 --------------
Dec-12Gas34,551 29,110 25,321 27,774 16,532 --------------
Jan-13Gas33,104 30,121 27,797 30,568 19,353 --------------
Feb-13Gas26,963 19,106 21,496 18,109 13,237 -----3,615 --------
Mar-13Gas21,206 27,141 24,740 16,144 7,484 -----9,938 --------
Apr-13Gas18,146 19,635 22,798 12,855 --4,256 -1,885 -13,491 --------
May-13Gas16,883 14,543 18,551 14,246 --11,977 -6,811 -11,469 7,026 --39,213 43,260 42,688 --
Jun-13Gas16,386 9,408 13,515 3,788 --27,268 -29,107 -8,927 16,591 --39,609 35,297 36,850 --
Jul-13Gas16,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-13Gas15,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-13Gas14,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-13Gas10,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-13Gas-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-13Gas-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-14Gas-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-14Gas-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-14Gas-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-14Gas4,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-14Gas6,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-14Gas286 -----------582 -512 249 411 --
Jul-14Gas-------------------
Aug-14Gas-------------------
Sep-14Gas-------------------
Oct-14Gas-------------------
Nov-14Gas-------------------
Dec-14Gas-------------------
OilJan-13Feb-13Mar-13Apr-13May-13Jun-13Jul-13Aug-13Sep-13Oct-13Nov-13Dec-13Total
Banduch 1H0
Golden B 10H0
Golden B 2H0
Golden B 4H0
Golden B 6H0
Golden B 8H0
Greaves A 1H0
Greaves A 2H0
Greaves B 1H0
Greaves B 2H0
Greaves B 3H0
Greaves B 4H0
Greaves B 5H0
Greaves B 6H0
KC 3H0
KC 4H0
Moczygemba 1H0
Seifert C 1H0
Smolik A 1H0
0000000000000
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Russell Hauf

MrExcel MVP
Joined
Feb 10, 2002
Messages
1,611
Does a pivot table not suit your needs? Page field could contain your "data validation" toggle...
 

jazzista

Board Regular
Joined
Sep 15, 2014
Messages
86
Russell: I have tried the pivot table, but because of the way the data was populated ( Wells), they duplicate each other up in the columns.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,553
Messages
5,596,807
Members
414,104
Latest member
imamalidadashzada

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top