Spreadsheet: 87730d1287590999-help-in-sumif-pivottablepricereg
Sheet: data

Day | Day | Campaign | Price | Register
Friday | 2010-10-01 00:00:00 | Australia Content | 39.11 | 6
Friday | 2010-10-01 00:00:00 | Australia Search | 2.31 | 1
Friday | 2010-10-01 00:00:00 | Australia Search | 0.72 | 0
Friday | 2010-10-01 00:00:00 | Australia Search | 4.49 | 0
Friday | 2010-10-01 00:00:00 | Australia Search | 2.6 | 0
Friday | 2010-10-01 00:00:00 | Australia Search | 6.56 | 1
Friday | 2010-10-01 00:00:00 | Australia Search | 0.38 | 0
Friday | 2010-10-01 00:00:00 | Australia Content | 0 | 0
Friday | 2010-10-01 00:00:00 | Australia Content | 6.49 | 3
Friday | 2010-10-01 00:00:00 | Australia Content | 0 | 0
Friday | 2010-10-01 00:00:00 | Australia Content | 1.4 | 0
Friday | 2010-10-01 00:00:00 | Australia Content | 2.49 | 0
Friday | 2010-10-01 00:00:00 | Australia Search | 1.28 | 0
Friday | 2010-10-01 00:00:00 | Australia Content | 55.48 | 5
Friday | 2010-10-01 00:00:00 | Australia Search | 7.43 | 2
Friday | 2010-10-01 00:00:00 | Australia Content | 12.68 | 3
Friday | 2010-10-01 00:00:00 | Australia Search | 0 | 0
Friday | 2010-10-01 00:00:00 | Australia Search | 0 | 0
Friday | 2010-10-01 00:00:00 | Australia Search | 1.14 | 0
Friday | 2010-10-01 00:00:00 | Australia Search | 0 | 0
Friday | 2010-10-01 00:00:00 | Australia Search | 0 | 0
Friday | 2010-10-01 00:00:00 | Australia Search | 2.15 | 1
Friday | 2010-10-01 00:00:00 | Australia Search | 1.71 | 0
Friday | 2010-10-01 00:00:00 | TMJ AU Image Ads | 1.46 | 0
Friday | 2010-10-01 00:00:00 | TMJ AU Image Ads | 8.31 | 0
Friday | 2010-10-01 00:00:00 | TMJ AU Image Ads | 0.66 | 0
Friday | 2010-10-01 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Friday | 2010-10-01 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Friday | 2010-10-01 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Friday | 2010-10-01 00:00:00 | TMJ AU Image Ads - 2 | 1.21 | 0
Friday | 2010-10-01 00:00:00 | TMJ AU Image Ads - 2 | 1.56 | 0
Saturday | 2010-10-02 00:00:00 | Australia Content | 20.48 | 1
Saturday | 2010-10-02 00:00:00 | Australia Search | 1.8 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 1.48 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 10.74 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 1.83 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 2.95 | 1
Saturday | 2010-10-02 00:00:00 | Australia Search | 1.68 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 29.98 | 1
Saturday | 2010-10-02 00:00:00 | Australia Search | 1.24 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 3.6 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 1.22 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 2.88 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 2.11 | 0
Saturday | 2010-10-02 00:00:00 | Australia Content | 3.54 | 1
Saturday | 2010-10-02 00:00:00 | Australia Content | 11.1 | 0
Saturday | 2010-10-02 00:00:00 | Australia Content | 0 | 0
Saturday | 2010-10-02 00:00:00 | Australia Content | 0 | 0
Saturday | 2010-10-02 00:00:00 | Australia Content | 1.1 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 9.99 | 2
Saturday | 2010-10-02 00:00:00 | Australia Content | 23.33 | 3
Saturday | 2010-10-02 00:00:00 | Australia Search | 3.78 | 1
Saturday | 2010-10-02 00:00:00 | Australia Content | 3.94 | 2
Saturday | 2010-10-02 00:00:00 | Australia Search | 0 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 3.17 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 0 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 0 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 1.38 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 0 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 0 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 4.63 | 1
Saturday | 2010-10-02 00:00:00 | Australia Search | 0.69 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 0 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 0 | 0
Saturday | 2010-10-02 00:00:00 | Australia Search | 0.73 | 0
Saturday | 2010-10-02 00:00:00 | TMJ AU Image Ads | 1.17 | 0
Saturday | 2010-10-02 00:00:00 | TMJ AU Image Ads | 1.11 | 0
Saturday | 2010-10-02 00:00:00 | TMJ AU Image Ads | 0 | 0
Saturday | 2010-10-02 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Saturday | 2010-10-02 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Saturday | 2010-10-02 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Saturday | 2010-10-02 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Saturday | 2010-10-02 00:00:00 | TMJ AU Image Ads - 2 | 3.28 | 1
Sunday | 2010-10-03 00:00:00 | Australia Content | 28.72 | 5
Sunday | 2010-10-03 00:00:00 | Australia Search | 5.35 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0.65 | 1
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 11.07 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 6.06 | 1
Sunday | 2010-10-03 00:00:00 | Australia Search | 1.22 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 1.66 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 33.96 | 2
Sunday | 2010-10-03 00:00:00 | Australia Search | 1.24 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 4.16 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 6.72 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 1.42 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 2.88 | 0
Sunday | 2010-10-03 00:00:00 | Australia Content | 1.12 | 0
Sunday | 2010-10-03 00:00:00 | Australia Content | 3.18 | 0
Sunday | 2010-10-03 00:00:00 | Australia Content | 1.6 | 0
Sunday | 2010-10-03 00:00:00 | Australia Content | 2.61 | 1
Sunday | 2010-10-03 00:00:00 | Australia Content | 2.58 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 3.82 | 0
Sunday | 2010-10-03 00:00:00 | Australia Content | 65.12 | 9
Sunday | 2010-10-03 00:00:00 | Australia Search | 8.43 | 1
Sunday | 2010-10-03 00:00:00 | Australia Content | 19.16 | 1
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 7.37 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 1.32 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0.84 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 2.89 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 1.12 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 2.4 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 0 | 0
Sunday | 2010-10-03 00:00:00 | Australia Search | 10.28 | 1
Sunday | 2010-10-03 00:00:00 | TMJ AU Image Ads | 0 | 0
Sunday | 2010-10-03 00:00:00 | TMJ AU Image Ads | 0 | 0
Sunday | 2010-10-03 00:00:00 | TMJ AU Image Ads | 1.99 | 0
Sunday | 2010-10-03 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Sunday | 2010-10-03 00:00:00 | TMJ AU Image Ads - 2 | 1.24 | 0
Sunday | 2010-10-03 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Sunday | 2010-10-03 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Sunday | 2010-10-03 00:00:00 | TMJ AU Image Ads - 2 | 8.2 | 0
Monday | 2010-10-04 00:00:00 | Australia Content | 40.3 | 1
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 1.08 | 1
Monday | 2010-10-04 00:00:00 | Australia Search | 7.79 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 11.5 | 1
Monday | 2010-10-04 00:00:00 | Australia Search | 2.23 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 1.52 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 1.53 | 1
Monday | 2010-10-04 00:00:00 | Australia Search | 12.99 | 1
Monday | 2010-10-04 00:00:00 | Australia Search | 0.72 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 1.73 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 1.24 | 1
Monday | 2010-10-04 00:00:00 | Australia Search | 2.79 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 3.49 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 1.34 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 1.23 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0.32 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 9.82 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 1.93 | 0
Monday | 2010-10-04 00:00:00 | Australia Content | 5.76 | 1
Monday | 2010-10-04 00:00:00 | Australia Content | 5.06 | 1
Monday | 2010-10-04 00:00:00 | Australia Content | 2.41 | 2
Monday | 2010-10-04 00:00:00 | Australia Content | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Content | 3.37 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 1.63 | 0
Monday | 2010-10-04 00:00:00 | Australia Content | 67.89 | 11
Monday | 2010-10-04 00:00:00 | Australia Search | 8.38 | 1
Monday | 2010-10-04 00:00:00 | Australia Content | 11.46 | 2
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 4.3 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 2.16 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0.66 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 1.04 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 1.45 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 0 | 0
Monday | 2010-10-04 00:00:00 | Australia Search | 4.77 | 1
Monday | 2010-10-04 00:00:00 | Australia Search | 2.22 | 0
Monday | 2010-10-04 00:00:00 | TMJ AU Image Ads | 0 | 0
Monday | 2010-10-04 00:00:00 | TMJ AU Image Ads | 0 | 0
Monday | 2010-10-04 00:00:00 | TMJ AU Image Ads | 0 | 0
Monday | 2010-10-04 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Monday | 2010-10-04 00:00:00 | TMJ AU Image Ads - 2 | 2.26 | 0
Monday | 2010-10-04 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Monday | 2010-10-04 00:00:00 | TMJ AU Image Ads - 2 | 0.56 | 0
Monday | 2010-10-04 00:00:00 | TMJ AU Image Ads - 2 | 2.08 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Content | 69.27 | 11
Tuesday | 2010-10-05 00:00:00 | Australia Search | 5.41 | 1
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0.93 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 1.25 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 2.55 | 1
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 4.77 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 7.79 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 3.33 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 18.01 | 1
Tuesday | 2010-10-05 00:00:00 | Australia Search | 1.86 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 1.34 | 1
Tuesday | 2010-10-05 00:00:00 | Australia Search | 2.74 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0 |  | Defined Name = DataSet = =[NAME]:INDEX(data!$A$1:$E$20000,COUNTA(data!$A$1:$A$20000),5)
Tuesday | 2010-10-05 00:00:00 | Australia Search | 6.52 | 0 |  | I chose 20000 as a maximum expected # of rows, you can increase this
Tuesday | 2010-10-05 00:00:00 | Australia Search | 2.02 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 3.51 | 1
Tuesday | 2010-10-05 00:00:00 | Australia Content | 4.55 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Content | 4.5 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Content | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Content | 1.62 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Content | 2.03 | 1
Tuesday | 2010-10-05 00:00:00 | Australia Search | 3.63 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Content | 81.77 | 13
Tuesday | 2010-10-05 00:00:00 | Australia Search | 12.26 | 1
Tuesday | 2010-10-05 00:00:00 | Australia Content | 15.87 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 4.32 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 1.53 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 4.71 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 0.76 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 2.79 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 1.8 | 1
Tuesday | 2010-10-05 00:00:00 | Australia Search | 1.26 | 0
Tuesday | 2010-10-05 00:00:00 | Australia Search | 9.75 | 1
Tuesday | 2010-10-05 00:00:00 | Australia Search | 1.48 | 1
Tuesday | 2010-10-05 00:00:00 | TMJ AU Image Ads | 0 | 0
Tuesday | 2010-10-05 00:00:00 | TMJ AU Image Ads | 0 | 0
Tuesday | 2010-10-05 00:00:00 | TMJ AU Image Ads | 0 | 0
Tuesday | 2010-10-05 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Tuesday | 2010-10-05 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Tuesday | 2010-10-05 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Tuesday | 2010-10-05 00:00:00 | TMJ AU Image Ads - 2 | 0 | 0
Tuesday | 2010-10-05 00:00:00 | TMJ AU Image Ads - 2 | 1.2 | 0