Hello Mr. Excel Board,
I had created a separate thread yesterday asking for help using VLOOKUP for multiple criteria, but it turns out that I may instead need to use SUMPRODUCT according to one of the users which replied to my other thread. Basically, what I would like to do is show the data from only the previous day for a particular line item for a report. I think I got it to work semi-correctly, but instead of a numerical value, I get "FALSE" which isn't the desired result. Screenshots are included for where I'd like the data to appear and the sheet where this data is coming from.
Thanks!
I need to pull data for the previous day from the "oas" tab which can be seen below. The date format I'm using, if needed to help with this, is 'mm/dd/yyyy'.
I had created a separate thread yesterday asking for help using VLOOKUP for multiple criteria, but it turns out that I may instead need to use SUMPRODUCT according to one of the users which replied to my other thread. Basically, what I would like to do is show the data from only the previous day for a particular line item for a report. I think I got it to work semi-correctly, but instead of a numerical value, I get "FALSE" which isn't the desired result. Screenshots are included for where I'd like the data to appear and the sheet where this data is coming from.
Thanks!
| Excel Workbook | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
| 4 | Yesterday's Date | 5/19/2010 | ||||||||||||||||
| 5 | ||||||||||||||||||
| 6 | ||||||||||||||||||
| 7 | ||||||||||||||||||
| 8 | Sum of Total Imps | |||||||||||||||||
| 9 | Opportunity Name | Campaign | Placement Description | AD Line Item No. | 3rd Party Billing | Agency Adserver | Actual Start Date | Actual End Date | Ad Date | End Date | Ad Size | Ad Type | Quantity | OAS Scheduled Imps | Total | Yesterday's Delivery | ||
| 10 | abc video upfront_q2 2010 | #N/A | Guaranteed Video Views | TO0003443_1 | 0 | (blank) | 5/18/2010 | 5/24/2010 | 5/18/2010 | 8/24/2010 | 300x250 | #N/A | 120,000 | #N/A | - | #N/A | ||
| 11 | Air Force_Air Force 2010_Q2Q310 | TO0003247_14-Airforce-728x90 | Tagged Social media distribution --> Targeted media across Appssavvys most popular applications for men | TO0003247_14 | 0 | (blank) | 5/10/2010 | 10/31/2010 | 6/1/2010 | 6/14/2010 | 728x90 | IAB | 666,667 | 666,667 | 2 | FALSE | ||
| 12 | TO0003247_15-Airforce-728x90 | Where I've Been Social media distribution --> Targeted media across Appssavvys most popular applications for men | TO0003247_15 | 0 | (blank) | 5/10/2010 | 10/31/2010 | 5/10/2010 | 10/31/2010 | 728x90 | IAB | 333,333 | 333,334 | 18 | #N/A | |||
| 13 | TO0003247_16-Airforce-728x90 | Page Fad Social media distribution --> Targeted media across Appssavvys most popular applications for men | TO0003247_16 | 0 | (blank) | 5/10/2010 | 10/31/2010 | 5/10/2010 | 10/31/2010 | 728x90 | IAB | 333,333 | 333,334 | 12,228 | #N/A | |||
| 14 | TO0003247_17-Airforce-300x250 | Where I've Been Social media distribution --> Targeted media across Appssavvys most popular applications for men | TO0003247_17 | 0 | (blank) | 5/10/2010 | 10/31/2010 | 5/10/2010 | 10/31/2010 | 300x250 | IAB | 666,667 | 666,667 | 17,623 | #N/A | |||
scrumdetail | ||||||||||||||||||
I need to pull data for the previous day from the "oas" tab which can be seen below. The date format I'm using, if needed to help with this, is 'mm/dd/yyyy'.
| Excel Workbook | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | Alt Ad ID | Date | Campaign | Imps* | Clicks | CTR | ||
| 2 | RE06-AppssavvyB | 5/1/2010 | RE06-AppssavvyB-728x90 | 0 | 2 | 0.00% | ||
| 3 | TO0002118_2 | 5/1/2010 | TO0002118_2-PampersSwad-1x1 | 10,014 | - | 0.00% | ||
| 4 | TO0002119_1 | 5/1/2010 | TO0002119_1-PampersSen-728x90 | 2 | - | 0.00% | ||
| 5 | TO0002119_2 | 5/1/2010 | TO0002119_2-PampersSen-160x600 | 2,009 | - | 0.00% | ||
| 6 | TO0002120_1 | 5/1/2010 | TO0002120_1-PampersEasy-1x1 | 4,936 | - | 0.00% | ||
| 7 | TO0002120_2 | 5/1/2010 | TO0002120_2-PampersEasy-728x90 | 5 | - | 0.00% | ||
| 8 | TO0002120_3 | 5/1/2010 | TO0002120_3-PampersEasy-160x600 | 1,167 | - | 0.00% | ||
oas | ||||||||
