Spreadsheet: 92165d1291823002-sumifs-sample1
Sheet: Sheet1

Antivirus
Newsletter | From | Date | Subject | Sends | Opens | Clicks | Send Group | Open Rate | [NAME] | Sales | Conversion
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 10177 | 360 | 20 | Office |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 38365 | 934 | 77 | Music |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 4712 | 192 | 13 | Earth |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 116088 | 1990 | 216 | Movies |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 27954 | 900 | 56 | Flash |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 48576 | 1950 | 140 | PDF |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 23998 | 631 | 72 | TV |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 21370 | 724 | 91 | Antivirus |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 45083 | 1220 | 83 | [NAME] |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 28742 | 1412 | 116 | Earth |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 65122 | 1932 | 117 | Flash |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 314229 | 8223 | 771 | Movies |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 68316 | 1849 | 133 | [NAME] |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 67111 | 2201 | 175 | Antivirus |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 20578 | 885 | 40 | Office |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 156238 | 4511 | 320 | Music |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 45602 | 1328 | 86 | PDF |  |  | 34
[NAME] | Private Message | 2010-11-16 00:00:00 | [NAME] You a Message | 61535 | 1594 | 151 | TV |  |  | 34
Img Data Loss | Antivirus 2010 | 2010-11-16 00:00:00 | Protect Your Computer From Total Data Loss | 151229 | 1014 | 95 | Movies |  |  | 22
Img Data Loss | Antivirus 2010 | 2010-11-16 00:00:00 | Protect Your Computer From Total Data Loss | 5988 | 106 | 10 | Earth |  |  | 22
Img Data Loss | Antivirus 2010 | 2010-11-16 00:00:00 | Protect Your Computer From Total Data Loss | 1760 | 31 | 2 | Office |  |  | 22
Img Data Loss | Antivirus 2010 | 2010-11-16 00:00:00 | Protect Your Computer From Total Data Loss | 35647 | 310 | 30 | TV |  |  | 22
Img Data Loss | Antivirus 2010 | 2010-11-17 00:00:00 | Protect Your Computer From Total Data Loss | 48943 | 946 | 54 | PDF |  |  | 22
Img Data Loss | Antivirus 2010 | 2010-11-17 00:00:00 | Protect Your Computer From Total Data Loss | 56195 | 782 | 31 | [NAME] |  |  | 22
Img Data Loss | Antivirus 2010 | 2010-11-17 00:00:00 | Protect Your Computer From Total Data Loss | 50421 | 388 | 25 | Music |  |  | 22
Img Data Loss | Antivirus 2010 | 2010-11-17 00:00:00 | Protect Your Computer From Total Data Loss | 48945 | 682 | 44 | Flash |  |  | 22
Img Data Loss | Antivirus 2010 | 2010-11-17 00:00:00 | Protect Your Computer From Total Data Loss | 31988 | 367 | 35 | Antivirus |  |  | 22
Img Data Loss | Antivirus 2010 | 2010-11-17 00:00:00 | Protect Your Computer From Total Data Loss | 67532 | 1133 | 72 | Antivirus |  |  | 22
Img Data Loss | Antivirus 2010 | 2010-11-17 00:00:00 | Protect Your Computer From Total Data Loss | 156447 | 2518 | 103 | Music |  |  | 22
Img Data Loss | AV Protection Plus | 2010-11-17 00:00:00 | Protect Your Computer From Total Data Loss | 19842 | 858 | 52 | PDF |  |  | 22
Img Data Loss | AV Protection Plus | 2010-11-17 00:00:00 | Protect Your Computer From Total Data Loss | 30359 | 242 | 13 | [NAME] |  |  | 22
Img Data Loss | AV Protection Plus | 2010-11-17 00:00:00 | Protect Your Computer From Total Data Loss | 13588 | 141 | 7 | Antivirus |  |  | 22
Img Data Loss | AV Protection Plus | 2010-11-17 00:00:00 | Protect Your Computer From Total Data Loss | 15718 | 101 | 9 | Music |  |  | 22
[NAME] | Antivirus 2010 | 2010-11-17 00:00:00 | Homeland Security's Go To AntiVirus | 21114 | 411 | 40 | Antivirus |  |  | 2
[NAME] | Antivirus 2010 | 2010-11-17 00:00:00 | Homeland Security's Go To AntiVirus | 38338 | 438 | 19 | Music |  |  | 2
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 34061 | 498 | 21 | PDF |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 41678 | 505 | 40 | Antivirus |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 46692 | 460 | 25 | [NAME] |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 54924 | 675 | 45 | Flash |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 80531 | 713 | 42 | Music |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 36638 | 317 | 17 | [NAME] |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 18485 | 210 | 13 | Flash |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 35408 | 218 | 9 | Music |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 17904 | 191 | 23 | Antivirus |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 22595 | 402 | 19 | PDF |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 35776 | 733 | 58 | Antivirus |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 86379 | 1448 | 55 | Music |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 12031 | 400 | 19 | PDF |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 10024 | 69 | 11 | [NAME] |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 19634 | 140 | 17 | Music |  |  | 33
Img Identity | AV Security Update | 2010-11-17 00:00:00 | Computer Viruses Can Now Steal Your Identity | 11043 | 153 | 15 | Antivirus |  |  | 33
Ransomware | New Antivirus Release | 2010-11-17 00:00:00 | Viruses Can Blackmail You About Your Browising History | 245480 | 2616 | 67 | Music |  |  | 2
Ransomware | New Antivirus Release | 2010-11-17 00:00:00 | Viruses Can Blackmail You About Your Browising History | 128931 | 1474 | 42 | Antivirus |  |  | 2
Ransomware | New Antivirus Release | 2010-11-17 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 12013 | 206 | 15 | PDF |  |  | 1
Ransomware | New Antivirus Release | 2010-11-17 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 28064 | 227 | 9 | Music |  |  | 1
Ransomware | New Antivirus Release | 2010-11-17 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 13406 | 74 | 6 | [NAME] |  |  | 1
Ransomware | New Antivirus Release | 2010-11-17 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 3676 | 46 | 3 | Flash |  |  | 1
Ransomware | New Antivirus Release | 2010-11-17 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 20589 | 195 | 12 | Antivirus |  |  | 1
Ransomware | New Antivirus Release | 2010-11-17 00:00:00 | Viruses Can Blackmail You About Your Browising History | 112259 | 1807 | 52 | Music |  |  | 44
Ransomware | New Antivirus Release | 2010-11-17 00:00:00 | Viruses Can Blackmail You About Your Browising History | 47540 | 607 | 10 | [NAME] |  |  | 44
Ransomware | New Antivirus Release | 2010-11-17 00:00:00 | Viruses Can Blackmail You About Your Browising History | 24398 | 439 | 24 | Antivirus |  |  | 44
Ransomware | New Antivirus Release | 2010-11-17 00:00:00 | Viruses Can Blackmail You About Your Browising History | 1760 | 34 | 2 | Office |  |  | 44
Ransomware | New Antivirus Release | 2010-11-17 00:00:00 | Viruses Can Blackmail You About Your Browising History | 35646 | 328 | 33 | TV |  |  | 44
Ransomware | [NAME] | 2010-11-17 00:00:00 | Viruses Can Blackmail You About Your Browising History | 38228 | 666 | 23 | Music |  |  | 44
Ransomware | [NAME] | 2010-11-17 00:00:00 | Viruses Can Blackmail You About Your Browising History | 15039 | 424 | 22 | Antivirus |  |  | 44
Ransomware | [NAME] | 2010-11-17 00:00:00 | Viruses Can Blackmail You About Your Browising History | 11738 | 283 | 16 | Flash |  |  | 44
Ransomware | [NAME] | 2010-11-17 00:00:00 | Viruses Can Blackmail You About Your Browising History | 15787 | 683 | 30 | PDF |  |  | 44
Ransomware | [NAME] | 2010-11-17 00:00:00 | Viruses Can Blackmail You About Your Browising History | 157618 | 2603 | 78 | [NAME] |  |  | 44
[NAME] | New Antivirus Release | 2010-11-23 00:00:00 | Homeland Security's Go To AntiVirus | 132066 | 680 | 42 | Movies |  |  | 3
[NAME] | New Antivirus Release | 2010-11-23 00:00:00 | Homeland Security's Go To AntiVirus | 7837 | 160 | 4 | Earth |  |  | 3
[NAME] | New Antivirus Release | 2010-11-23 00:00:00 | Homeland Security's Go To AntiVirus | 31352 | 372 | 28 | TV |  |  | 3
[NAME] | New Antivirus Release | 2010-11-23 00:00:00 | Homeland Security's Go To AntiVirus | 4278 | 47 | 2 | Office |  |  | 3
Ransomware | Antivirus for Windows | 2010-11-23 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 5011 | 63 | 1 | Office |  |  | 1
Ransomware | Antivirus for Windows | 2010-11-23 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 38551 | 535 | 21 | TV |  |  | 1
Ransomware | Antivirus for Windows | 2010-11-23 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 17879 | 534 | 32 | Earth |  |  | 1
Ransomware | Antivirus for Windows | 2010-11-23 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 111235 | 629 | 27 | Movies |  |  | 1
Ransomware | Antivirus 2010 | 2010-11-23 00:00:00 | Viruses Can Blackmail You About Your Browising History | 36410 | 304 | 13 | TV |  |  | 7
Ransomware | Antivirus 2010 | 2010-11-23 00:00:00 | Viruses Can Blackmail You About Your Browising History | 16370 | 237 | 14 | Office |  |  | 7
Ransomware | Antivirus 2010 | 2010-11-23 00:00:00 | Viruses Can Blackmail You About Your Browising History | 107090 | 532 | 23 | Movies |  |  | 7
Ransomware | Antivirus 2010 | 2010-11-23 00:00:00 | Viruses Can Blackmail You About Your Browising History | 4833 | 57 | 3 | Earth |  |  | 7
Img Data Loss | New Antivirus Release | 2010-11-23 00:00:00 | Protect Your Computer From Total Data Loss | 5929 | 115 | 5 | Earth |  |  | 88
Img Data Loss | New Antivirus Release | 2010-11-23 00:00:00 | Protect Your Computer From Total Data Loss | 35378 | 307 | 22 | TV |  |  | 88
Img Data Loss | New Antivirus Release | 2010-11-23 00:00:00 | Protect Your Computer From Total Data Loss | 150751 | 1004 | 76 | Movies |  |  | 88
Img Data Loss | New Antivirus Release | 2010-11-23 00:00:00 | Protect Your Computer From Total Data Loss | 1743 | 30 | 4 | Office |  |  | 88
Ransomware | Antivirus for Windows | 2010-11-23 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 5011 | 63 | 1 | Office |  |  | 5
Ransomware | Antivirus for Windows | 2010-11-23 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 38551 | 535 | 21 | TV |  |  | 5
Ransomware | Antivirus for Windows | 2010-11-23 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 111235 | 630 | 27 | Movies |  |  | 5
Ransomware | Antivirus for Windows | 2010-11-23 00:00:00 | Viruses that Monitor Your Surfing Habits - Must Read | 17879 | 535 | 34 | Earth |  |  | 5
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 40093 | 1015 | 61 | PDF |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 45032 | 788 | 50 | [NAME] |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 4873 | 152 | 11 | Earth |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 25401 | 514 | 46 | Antivirus |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 117757 | 1095 | 144 | Movies |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 38288 | 490 | 41 | Music |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 36841 | 715 | 61 | Flash |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 8536 | 221 | 15 | Office |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 62113 | 2161 | 152 | [NAME] |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 43590 | 2100 | 215 | Antivirus |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 296003 | 9874 | 969 | Movies |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 75570 | 2406 | 191 | Music |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 8323 | 320 | 17 | Office |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 109840 | 5018 | 575 | TV |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 44931 | 3313 | 320 | Earth |  |  | 1
[NAME] | Private Message | 2010-11-24 00:00:00 | [NAME] You a Message | 21942 | 1438 | 80 | PDF |  |  | 1
Img New | New Antivirus Release | 2010-12-06 00:00:00 | The Most Popular AVG Alternative is Here | 40151 | 423 | 26 | [NAME] |  |  | 2 | 0.0454
Img New | New Antivirus Release | 2010-12-06 00:00:00 | The Most Popular AVG Alternative is Here | 31064 | 471 | 29 | PDF |  |  | 2 | 0.0454
Img New | New Antivirus Release | 2010-12-06 00:00:00 | The Most Popular AVG Alternative is Here | 46989 | 677 | 62 | Flash |  |  | 2 | 0.0454
Img New | New Antivirus Release | 2010-12-06 00:00:00 | The Most Popular AVG Alternative is Here | 66344 | 638 | 39 | Music |  |  | 2 | 0.0454
Img New | New Antivirus Release | 2010-12-06 00:00:00 | The Most Popular AVG Alternative is Here | 36325 | 533 | 64 | Antivirus |  |  | 2 | 0.0454
 |  |  | This represent all the sales for " The Most Popular AVG Alternative is Here" subject line sent on that Dec 6,
 |  |  | want to take all the sales (2 and not 10) and divide it by clicks (220) and have it appear in column L