Spreadsheet: 53207d1253130185-excel-2007-calculate-average-on-filtered-data-only-book2
Sheet: Sheet1

 | Promo Product Summary |  |  |  |  |  | Calculate Average of What is Filtered |  | 2.35290243902439
 | Ad Information |  |  |  |  |  |  | Promotion Analysis
 | Account | Date (WS) | Location | Price Type | Products | Price | Notes | Analysis (y/n) | Return   $ | Lift Incr/Base | Promo Grade | Comment
 | Store # 1 | 2009-03-13 00:00:00 | P10/12 | Non | Product # 1 | 7.99 | [NAME] | yes | 6.33 | 2.4 | B
 | Store # 2 | 2009-02-13 00:00:00 | P01/10 | Non | Product # 1 | 5.99 | [NAME] | yes | 1.05 | 2.3 | [NAME]
 | Store # 2 | 2009-02-27 00:00:00 | P01/12 | Multiple | Product # 1 | 6.99 | [NAME] | yes | 1.44 | 13.1 | [NAME]
 | Store # 2 | 2009-04-17 00:00:00 | P20/24 | Multiple | Product # 1 | 6 | [NAME] | yes | 1.04 | 17.7 | [NAME]
 | Store # 2 | 2009-01-16 00:00:00 | P04/10 | Non | Product # 2 | 1.99 | [NAME] | yes | 1.83 | 9.1 | [NAME]
 | Store # 2 | 2009-01-30 00:00:00 | P08/10 | Multiple | Product # 3 | 5.99 | [NAME] | no
 | Store # 3 | 2009-04-23 00:00:00 | P07/10 | Non | Product # 1 | 7.99 | [NAME] | yes | 1.93 | 1.3
 | Store # 3 | 2009-04-02 00:00:00 | none | Non | Product # 2 | 2.01 | [NAME] | yes | 1.32 | 0.28
 | Store # 3 | 2009-04-23 00:00:00 | P07/10 | 2fer | Product # 2 | 2/$4.00 | [NAME] | yes | 0.49 | 0.46 | F
 | Store # 3 | 2009-07-09 00:00:00 | P04/08 | 2fer | Product # 2 | 2/$4.00 | [NAME] | TBD
 | Store # 3 | 2009-05-28 00:00:00 | P09/10 | 2fer | Product # 3 | 2/$12.00 | [NAME] | yes | 4.85 | 2.4
 | Store # 3 | 2009-06-25 00:00:00 | P09/10 | Multiple | Product # 3 | 5.99 | [NAME] | yes | 4.67 | 1.4
 | Store # 3 | 2009-07-09 00:00:00 | P07/08 | 2fer | Product # 3 | 2/$10.00 | [NAME] | TBD
 | Store # 3 | 2009-08-20 00:00:00 | P07/08 | 2fer | Product # 3 | 2/$10.00 | [NAME] | TBD
 | Store #4 | 2009-03-20 00:00:00 | P07/08 | Non | Product # 1 | 7.99 | [NAME] | yes | 6.39 | 3.9 | A-
 | Store #4 | 2009-04-17 00:00:00 | P01/08 | Multiple | Product # 1 | 4.99 | [NAME] | yes | 1.79 | 5 | A
 | Store #4 | 2009-05-15 00:00:00 | [NAME] | Non | Product # 1 | 6.99 | [NAME] | yes | 0.89 | 0.3 | F
 | Store #4 | 2009-06-12 00:00:00 | [NAME] | Non | Product # 1 | 7.99 | [NAME] | no
 | Store #4 | 2009-06-26 00:00:00 | [NAME] | Non | Product # 1 | 7.99 | [NAME] | no
 | Store #4 | 2009-07-31 00:00:00 | P13/14 | Multiple | Product # 1 | 6.99 | [NAME] | no
 | Store #4 | 2009-08-28 00:00:00 | P07/14 | Multiple | Product # 1 | 5.99 | [NAME] | no
 | Store #4 | 2009-03-13 00:00:00 | P10/13 | 2fer | Product # 2 | 2/$5.00 | [NAME] | yes | 7.09 | 1 | C-
 | Store #4 | 2009-03-20 00:00:00 | P07/11 | 2fer | Product # 2 | 2/$5.00 | [NAME] | yes | 7.21 | 0.8 | C
 | Store #4 | 2009-04-03 00:00:00 | P14/18 | 2fer | Product # 2 | 2/$5.00 | [NAME] | yes | 6.61 | 0.75 | C
 | Store #4 | 2009-04-17 00:00:00 | P01/08 | 2fer | Product # 2 | 2/$4.00 | [NAME] | yes | 10.75 | 1.3 | B
 | Store #4 | 2009-05-15 00:00:00 | [NAME] | 2fer | Product # 2 | 2/$5.00 | [NAME] | yes | 2.72 | 0.3 | D
 | Store #4 | 2009-06-26 00:00:00 | [NAME] | 2fer | Product # 2 | 2/$4.00 | [NAME] | no
 | Store #4 | 2009-03-20 00:00:00 | P07/09 | Multiple | Product # 3 | 5.49 | [NAME] | yes | 2.52 | 5.5 | A
 | Store #4 | 2009-04-17 00:00:00 | P01/08 | Multiple | Product # 3 | 4.99 | [NAME] | yes | 3.9 | 9.6 | A
 | Store #4 | 2009-05-15 00:00:00 | [NAME] | Multiple | Product # 3 | 5.99 | [NAME] | yes | 3.31 | 3.7 | [NAME]
 | Store #4 | 2009-05-29 00:00:00 | P12/14 | Non | Product # 3 | 5.99 | [NAME] | no
 | Store #4 | 2009-08-28 00:00:00 | P07/14 | Multiple | Product # 3 | 5.99 | [NAME] | no
 | Store #5 | 2009-03-15 00:00:00 | [NAME] | Multiple | Product # 1 | 5.99 | [NAME] | yes | 7.59 | 5.4
 | Store #5 | 2009-04-12 00:00:00 | P04/16 | Multiple | Product # 1 | 5.99 | [NAME] | no | 1.6 | 3.03
 | Store #5 | 2009-06-07 00:00:00 | P14/20 | Multiple | Product # 1 | 5.99 | [NAME] | yes | 1.73 | 3.97
 | Store #5 | 2009-08-30 00:00:00 | P13/20 | Multiple | Product # 1 | 5.49 | [NAME] | TBD
 | Store #5 | 2009-01-04 00:00:00 | P04/16 | Non | Product # 2 | 1.99 | [NAME] | yes | 1.95 | 3.24
 | Store #5 | 2009-02-15 00:00:00 | P05/16 | Non | Product # 2 | 2.29 | [NAME] | yes | 1.77 | 0.74
 | Store #5 | 2009-03-15 00:00:00 | [NAME] | 2fer | Product # 2 | 1.99 | [NAME] | yes | 1.7 | 2.61
 | Store #5 | 2009-04-19 00:00:00 | P12/20 | Non | Product # 2 | 1.99 | [NAME] | yes | 1.87 | 4.86
 | Store #5 | 2009-06-28 00:00:00 | P14/20 | Non | Product # 2 | 2.99 | [NAME] | yes | 2.22 | 1.22
 | Store #5 | 2009-07-26 00:00:00 | P13/14 | Non | Product # 2 | 2.99 | [NAME] | TBD