Spreadsheet: 54992d1255033963-formula-help-for-locating-data-forum-20testlivesales-1-
Sheet: OX4

VAS | Sales | Refunds | Total |  | HOME MAX TOTAL | HOME SELECT TOTAL | HOME STARTER TOTAL | TOTAL BB CONNECTIONS
Unique Sale | 1 | 0 | 1 |  | 1 | 0 | 1 | 2
Student PAYG | 1 | 0 | 1
SIMO Racoon £20 | 1 | 0 | 1 |  | Choose words
Love Your Number | 4 | 0 | 4 |  | Contract | TOTAL PAYM & MBB SALES
SIMO Dolphin £15 | 1 | 0 | 1 |  | Dept Total: | 20
B'Berry Talk Cons | 7 | 0 | 7
18M UPG LRD + phone | 3 | 0 | 3
Orange Care Monthly | 5 | 0 | 5
18M UPG animal + phone | 2 | 0 | 2
24M UPG animal + phone | 1 | 0 | 1
28 Day Replacement PAYM | 1 | 0 | 1
Dept Total: | 27 | 0 | 27
 |  |  | 0
Sets | Sales | Refunds | #N/A
36 mth - £5 | 1 | 0 | 1
36 mth - £10 | 1 | 0 | 1
IEW 18 month 5 | 1 | 0 | 1
PAYG - Upgrade | 2 | 0 | 2
IEW 18 month 10 | 1 | 0 | 1
24 mth Racoon - £20 | 1 | 0 | 1
24 mth Racoon - £40 | 1 | 0 | 1
18 mth Dolphin - £35 | 1 | 1 | 0
18 mth Panther - £30 | 1 | 0 | 1
18 mth Panther - £35 | 1 | 0 | 1
24 mth Dolphin - £15 | 2 | 0 | 2
24 mth Panther - £25 | 1 | 0 | 1
24 mth Panther - £40 | 2 | 0 | 2
PAYG - New Connection | 22 | 0 | 22
IEW with laptop 5GB 24mth | 1 | 0 | 1
Dept Total: | 39 | 1 | 38
 |  |  | 0
E-Pay | Sales | Refunds | #N/A
£5 E - Voucher | 1 | 0 | 1
£10 E - Voucher | 4 | 0 | 4
£20 E - Voucher | 1 | 0 | 1
£30 E - Voucher | 1 | 0 | 1
£5 EPAY Airtime | 10 | 0 | 10
£10 EPAY Airtime | 26 | 0 | 26
£15 EPAY Airtime | 1 | 0 | 1
£20 EPAY Airtime | 11 | 0 | 11
£40 EPAY Airtime | 2 | 0 | 2
£50 EPAY Airtime | 1 | 0 | 1
Dept Total: | 58 | 0 | 58
 |  |  | 0
[NAME] | Sales | Refunds | #N/A
Sim Only PAYM | 2 | 0 | 2
SIM Giveaway Pack | 10 | 0 | 10
Pre-activated SIM Pack | 10 | 0 | 10
Dept Total: | 22 | 0 | 22
 |  |  | 0
[NAME] | Sales | Refunds | #N/A
Bill Payment | 9 | 0 | 9
Dept Total: | 9 | 0 | 9
 |  |  | 0
[NAME] | Sales | Refunds | #N/A
Orange Care PAYM | 2 | 0 | 2
BlackBerry 8520 Skins | 4 | 0 | 4
Dept Total: | 6 | 0 | 6
 |  |  | 0
Sets - Upgrade | Sales | Refunds | #N/A
UIC 5 Heavy | 2 | 0 | 2
UIC 3 Frequent | 2 | 0 | 2
UIC 4 Quite Heavy | 2 | 0 | 2
Dept Total: | 6 | 0 | 6
 |  |  | 0
Air Time Credit | Sales | Refunds | #N/A
NC £100 BB Instalment | 2 | 0 | 2
UPG £50 BB Instalment | 1 | 0 | 1
UPG £100 BB Instalment | 1 | 0 | 1
Dept Total: | 4 | 0 | 4
 |  |  | 0
Handsets - PAYG | Sales | Refunds | #N/A
Nokia 1661 | 1 | 0 | 1
Nokia 2330 | 2 | 0 | 2
Samsung E1120 | 2 | 0 | 2
LG KP501 Black | 1 | 0 | 1
BlackBerry 8120 | 1 | 0 | 1
AL OT S319 Black | 2 | 0 | 2
Sony Ericsson K850i | 8 | 0 | 8
Samsung E1360B Black | 1 | 0 | 1
BlackBerry 8120 Indigo | 1 | 0 | 1
Sony Ericsson W595 Pink | 4 | 0 | 4
Sony Ericsson W205 White | 1 | 0 | 1
Dept Total: | 24 | 0 | 24
 |  |  | 0
Stocked - Internet | Sales | Refunds | #N/A
Home Max | 1 | 0 | 1
Home Starter | 1 | 0 | 1
Dept Total: | 2 | 0 | 2
 |  |  | 0
Handsets - Contract | Sales | Refunds | #N/A
HTC Hero | 1 | 0 | 1
Nokia 2330 | 1 | 0 | 1
Nokia 5800 | 1 | 0 | 1
Nokia 6303 | 1 | 0 | 1
Nokia E71 Black | 1 | 0 | 1
Huawei E160 Black | 2 | 0 | 2
Samsung S5600 Pink | 1 | 0 | 1
Sony Ericsson C510 | 2 | 0 | 2
Sony Ericsson W595 | 1 | 0 | 1
Toshiba laptop 1G4 | 1 | 0 | 1
Samsung Tocco Black | 1 | 0 | 1
BlackBerry 9000 Bold | 3 | 0 | 3
BlackBerry Curve 8520 | 4 | 0 | 4
Sony Ericsson [NAME] | 1 | 1 | 0
Dept Total: | 21 | 1 | 20
 |  |  | 0
Stocked - Mains Chargers | Sales | Refunds | #N/A
Mains Samsung | 1 | 0 | 1
BlackBerry Curve Charger | 3 | 0 | 3
Dept Total: | 4 | 0 | 4
 |  |  | 0
Stocked - Cases/Phoneskins | Sales | Refunds | #N/A
Fashion Sock Butterflies | 1 | 0 | 1
Dept Total: | 1 | 0 | 1
Store Total: | 223 | 2 | 221
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0