SUMIFS and SUMIF Topics:
     Ex 1: Add w 1 condition.
     Ex 2: Add w 2 criteria.
     Ex3: Add w 3 criteria.
     Ex 4: Greater than
     Ex 5: Greater than or
     equal to
     Ex 6: Less than
     Ex 7: Less than or
     equal to
     Ex 8: Equal
     Ex 9: Not
     Ex 10: SUMIF if criteria & sum range are same: Saves Typing.
     Ex 11: Add w Comparative Operator - Criteria in Cell.
     Ex 12: Add w Comparative Operator - Criteria NOT in Cell.
     Ex 13: Add w 3 criteria, including "ALL": ?*
     Ex 14: Contains Criteria (Partial Text Match or Fuzzy Match).
     Ex 15: Any Customer with exactly 2 characters.
     Ex 16: Criteria typed DIRECTLY into formula (often times this is inefficient).
     Ex 17: SUMIFS copied down a column.
     Ex 18: SUMIFS copied down a column and across rows (copied to whole table).
     Ex 19: Sum Between Two Numbers (Lower Included, Upper Not).
     Ex 20: Sum Between Two Dates Inclusive.
     Ex 21: Sum Cells with Corresponding Empty Cells.
     Ex 22: Sum w/ Corr. Empty Cells or Null Text String.
     Ex 23: Sum w/ Corr.  NOT Empty Cells. (Add when there is text, numbers, Null Text String).
     Ex 24: Sum w/ Corr.  NOT Empty Cells or NOT Null Text String.
     Ex 25: Wildcard as Character: Use "~"& to tell SUMIFS to look for *
     Ex 26: Criteria for SUMIFS is not case sensitive.
     Ex 27: Case Sensitive: Use EXACT inside SUMPRODUCT.
     Ex 28: SUMIFS that looks to a different sheet.
     Ex 29: SUMIFS Can't Handle 3_D Cell References.
     Ex 30: SUMIFS to add from multiple columns across multiple sheets using INDIRECT and SUMPRODUCT functions.
     Ex 31: SUMIFS to add from multiple columns across multiple sheets using Sheet Reference and SUMIFS functions on each sheet.
     Ex 32: SUMIFS will not read external references when the workbook is closed.
     Ex 33: Solutions for SUMIFS with external references.
     Ex 34: SUMIFS with Year Criteria Mismatched against Serial Numbers.
     Ex 35: SUMIFS with Month As Text Criteria Mismatched against Serial Numbers.
     Ex 36: SUMIF with only 1 cell in sum_range is volatile.
          * SUMIFS = add with 1 or more criteria / condition. SUMIF = add with 1 criterion.
          * What we learn in this video is applicable to COUNTIFS, COUNTIF, AVERAGEIFS, and so on.
          * SUMIFS uses AND criteria - all criteria must be met for number to be added.
          * SUMIFS Faster calculating than DSUM and SUMPRODUCT equivalents.
          * SUMIFS Formula can be copied down a column, unlike DSUM.
          * SUMIFS Formulas update instantly when data changes, PivotTables don't.
          Date      Region    SalesRep Customer    Product   COGS Sales
            10/7/13SouthEast Tina      Amazon      COL Item    3642 6279 Ex 1: Add w 1 condition.
           10/26/12West       Chin     HD          AIM Item    3189 7416 Customer
            5/20/12North      Chin     OD          AIM Item    3636 6269 Amazon
            9/24/12MidWest    Sue      HD          RAD Item    2983 5423 * SUMIFS nice for 1 criteria because screen tips are less ambiguous than SUMIF.
            1/14/13MidWest    Fran     Economist   AIM Item    6386 6830 * Data Validation, List can prevent criteria that is not in list.
             4/3/12West       Tina     HD          RAD Item    1175 2611 * "?*" at the top of each list allows you to have criterion for
            1/20/13NorthEast Bat       Economist   DAB Item    2791 4811             ALL items in column that have at least 1 character.
            2/26/12SouthEast Tina      HM          RAD Item      15    22
           12/16/13MidWest    Gigi     OD          AIM Item    7222 8206 Ex 2: Add w 2 criteria.
             4/5/12NorthEast Bat       Amazon      AIM Item    4647 8450 Customer
            6/24/12NorthEast Tina      Yahoo       RAD Item    1264 2143 Amazon
            8/22/13SouthEast Chin      McLendon's RAD Item     3606 6112
            11/9/13NorthEast Pham      Costco      CIN Item     204   272
            3/23/13MidWest    Fran     HD          XOL Item     944 2552
            10/3/12MidWest    Sue      Peet's      RAD Item    9190 9829 Ex3: Add w 3 criteria.
             4/4/13MidWest    Bat      Amazon      AIM Item    3918 4453 Customer
             1/5/12NorthEast Shelia    HD          CIN Item    2945 5000 Amazon
            11/6/13NorthEast Gigi      WFM         AIM Item     564 1025 Region
            9/25/13SouthEast Sioux     Amazon      XOL Item    1504 2005 SouthEast
           11/12/13MidWest    Sioux    Economist   RAD Item    3505 8150
            12/7/12West       Gigi     Google      CIN Item    3846 6992 Comparative Operators
            11/5/13North      Sue      QFC         AIM Item    2510 5838 Ex 4: Greater than
                                                                           Ex 5: Greater than or
            9/30/13NorthEast Gigi      Peet's      CIN Item     628   923 equal to
            8/27/12NorthEast Fran      HM          AIM Item    1441 2443 Ex 6: Less than
                                                                           Ex 7: Less than or
            8/18/13NorthEast Gigi      OD          XOL Item    2992 3989 equal to
            2/19/12North      Tina     HM          RAD Item    7658 8702 Ex 8: Equal
           12/11/13NorthEast Gigi      McLendon's AIM Item     3141 5415 Ex 9: Not
            3/17/13NorthEast Pham      McLendon's COL Item      558 1298
            12/1/12North      Sioux    Economist   RAD Item     731 1238 Ex 10: SUMIF if criteria & sum range are same: Saves Typing.
             4/5/13NorthEast Fran      HM          NEE Item    4008 4555 Comparative Operators
             3/4/13MidWest    Sioux    Google      AIM Item    5246 5610 Greater
                                                                           Greater than or
            5/19/13West       Sioux    Google      AIM Item    1855 4313 equal
            4/25/12North      Sue      HD          COL Item    4662 6856 Less
                                                                       Less than or
            9/24/13West      Sue      OD         AIM Item   1267 2304 equal
            6/17/12MidWest   Tina     McLendon's NEE Item   6305 9272 Equal
            5/24/13SouthEast Sue      Fred Myer  CIN Item   6515 8687 Not
           10/20/13SouthEast Gigi     Economist  AIM Item     612 1360
             1/9/13North     Bill     HM         AIM Item   3330 7400
           12/29/12NorthEast Tina     Yahoo      COL Item     359  619
            9/13/13NorthEast Sioux    Yahoo      CIN Item   2307 6234 Ex 11: Add w Comparative Operator - Criteria in Cell.
            5/12/12NorthEast Gigi     Amazon     RAD Item   4765 8215 Customer
            7/29/12West      Pham     Costco     COL Item   4675 8501 Amazon
            4/12/13NorthEast Sioux    HM         NEE Item   4296 7408
             5/3/12NorthEast Bill     Costco     RAD Item   2076 3774
            7/17/12NorthEast Chin     Google     AIM Item   1210 1614
           11/16/13SouthEast Shelia   McLendon's XOL Item   5399 9309 Ex 12: Add w Comparative Operator - Criteria NOT in Cell.
            3/16/13SouthEast Sioux    WFM        AIM Item     606 1102 Customer
            8/17/13MidWest   Bill     Fred Myer  COL Item   3419 6216 Amazon
           10/13/12SouthEast Bill     Fred Myer  AIM Item   2705 3073
            9/26/13North     Chin     Amazon     RAD Item   5590 7454
            6/12/13SouthEast Pham     Google     RAD Item   3438 5928 * Advantage: Can use 5000 2 or more ways.
            4/15/12NorthEast Sioux    McLendon's COL Item   1182 3195
           12/30/13SouthEast Shelia   McLendon's COL Item   5338 7118 Ex 13: Add w 3 criteria, including "ALL": ?*
            9/15/12NorthEast Bill     HM         NEE Item   3251 4335 Customer
            5/11/12MidWest   Sioux    HD         CIN Item   3546 3792 ?*
             3/6/12SouthEast Tina     Google     DAB Item   3155 5347 Region
            9/18/12SouthEast Sioux    Google     COL Item     448  659 SouthEast
             4/6/13West      Bat      Costco     AIM Item   1935 2198 Wildcards:
             9/7/13North     Shelia   Amazon     DAB Item   5047 5398 * means 0 or more characters, where zero is a formula delivered Null Text String "".
            2/16/12SouthEast Pham     OD         RAD Item   4271 7364 ? Means 1 charatcer
           12/27/13North     Tina     WFM        AIM Item   5832 7777 ?* means 1 or more characters (avoids Null Text String)
            9/30/12MidWest   Fran     WFM        NEE Item     501 1354
           10/15/12MidWest   Fran     WFM        AIM Item     815 1382 Ex 14: Contains Criteria (Partial Text Match or Fuzzy Match).
           11/29/13West      Gigi     Fred Myer  DAB Item   2675 4533 Region
            3/28/12West      Tina     Economist  DAB Item   4341 7485 *North*
           10/21/13North     Bill     Costco     NEE Item   8597 9195
             3/2/12North     Gigi     QFC        DAB Item   3827 8505
             9/9/13West      Chin     Costco     DAB Item   1724 2972
             3/1/12MidWest   Gigi     Amazon     DAB Item   3186 8610 Ex 15: Any Customer with exactly 2 characters.
             3/7/13North     Tina     Costco     RAD Item   2672 4859 Customer
            5/16/13NorthEast Fran     Yahoo      COL Item     272  605 ??
           12/14/12NorthEast Sue      OD         AIM Item     948 2204 ?? means "Any Customer with exactly 2 characters."
            7/22/12NorthEast Sue      Peet's     CIN Item     650 1181
            9/26/12NorthEast Pham     McLendon's COL Item   1731 2985 Ex 16: Criteria typed DIRECTLY into formula (often times this is inefficient).
             4/1/12MidWest   Chin     HM         RAD Item   6032 6452 Total Sales For "North"
            4/20/13NorthEast Bat      QFC        NEE Item     641 1086
            1/11/12NorthEast Chin     Economist  COL Item   5217 5929 * Hard Coding formula elements that can change into your formula violates the
             8/7/12SouthEast Chin     Amazon     AIM Item   6550 7005     original intent of spreadhsheets.
            10/3/12MidWest   Fran     Yahoo      AIM Item   1461 3949 * The original intent of Bricklin and Frankston was that formula inputs be typed into
           12/11/13North     Pham     Google     XOL Item   3414 9226     cells and then refereed to with cell references.
            1/14/12MidWest   Tina     OD         CIN Item   2675 4863 * Excel's Golden Rule:
            7/24/12SouthEast Sioux    HD         AIM Item   3410 7578          * If formula inputs can change, type them into a cell and refer to them
             1/8/13North     Bill     McLendon's AIM Item   2173 3683            in formulas with cell references.
             6/7/12NorthEast Pham     Peet's     RAD Item   3387 7527          * If formula inputs will not change (like 24 hours in day, 12 months in year),
            2/17/13SouthEast Chin     Economist  DAB Item   2267 5272              then it can be efficient to type them directly into formula.
            6/10/12NorthEast Sue      Google     AIM Item   3412 5000
            10/7/13North     Shelia   Fred Myer  RAD Item   3465 6299 Ex 17: SUMIFS copied down a column.
            5/17/13NorthEast Sioux    Costco     RAD Item   2764 4766 Customer
            8/27/12West      Sue      Amazon     COL Item   4833 8787 Google
            4/20/12MidWest   Chin     McLendon's NEE Item   4502 6002 Region
            8/29/13NorthEast Bat      Economist  XOL Item   3729 4972 SouthEast
           12/19/13West      Fran     Fred Myer  RAD Item   5849 7799 North
            8/30/12MidWest   Fran     HM         CIN Item   3932 6779 NorthEast
            4/20/12MidWest   Gigi     HD         XOL Item   3970 9233 SouthEast
            9/16/12West      Tina     Fred Myer  AIM Item   1806 4880 West
            1/20/13NorthEast Fran     QFC        COL Item   2705 4665
            5/13/13NorthEast Tina     HD         RAD Item   4431 7640 Ex 18: SUMIFS copied down a column and across rows (copied to whole table).
            7/15/12North     Tina     Fred Myer  CIN Item   1909 2545 Add Sales
            10/2/12MidWest   Bat      HD         AIM Item   6663 7126 Customer
            12/6/13West      Pham     Google     RAD Item   2227 2531 Google
            10/9/13NorthEast Pham     McLendon's DAB Item   5386 7181 SalesRep/Region
             7/4/12NorthEast Bill     Economist  AIM Item   3442 5835 Bat
           10/13/12SouthEast Chin     Costco     XOL Item   2395 6474 Bill
             1/1/13NorthEast Pham     WFM        AIM Item   1252 2122 Chin
            8/28/12MidWest   Tina     HD         AIM Item   5349 7867 Fran
            8/27/13NorthEast Sue      Google     AIM Item   5843 6250 Gigi
            8/25/12West      Pham     HM         RAD Item   2050 3535 Pham
             8/3/12West      Sue      McLendon's AIM Item   8815 9427 Shelia
            4/18/12West      Sue      OD         DAB Item      45   82 Sioux
             8/9/12MidWest   Pham     Amazon     RAD Item   1371 2492 Sue
            1/11/13North     Sue      OD         DAB Item   3250 3475 Tina
            8/30/13SouthEast Chin     WFM        RAD Item   4483 6592
            6/10/13NorthEast Bill     Yahoo      XOL Item   5332 5702 Ex 19: Sum Between Two Numbers (Lower Included, Upper Not).
             8/4/13NorthEast Pham     Economist  NEE Item   2881 6701 Label
            5/13/13North     Fran     Google     AIM Item   2666 7206 0 <= Sales < 2500
             1/9/13NorthEast Tina     Economist  COL Item     726 1230 2500 <= Sales < 5000
            8/18/13NorthEast Chin     Amazon     RAD Item   2421 6543 5000 <= Sales < 7500
            8/10/12North     Pham     Amazon     DAB Item     234  266 7500 <= Sales < 10000
            2/15/12NorthEast Bat      McLendon's RAD Item      59  159 <  < <
           12/20/13SouthEast Fran     WFM        XOL Item   5877 9960 * Be sure to not 'Double Count'. If you include two = signs you may 'Double Count'.