Spreadsheet: 110133d1306900893-excel-2007-if-function-works-in-one-cell-and-not-the-next-forumhelp
Sheet: Sheet1

January
Customer | Sale Date | Car | N/U/D | RDA | Stock No | Del Date | Gross | Warranty | After/M | Finance | Pay | Sale No |  |  |  | New | Yes | 207 XR Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Demo | No | 207 XR Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 XT Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 XT Auto
 |  |  | Demo |  |  |  |  | Yes | Yes |  |  |  |  |  |  |  |  | 207 Sportium Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 Sportium Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 XT Diesel Man
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 Touring Diesel Man
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 Touring Petrol Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 CC Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 CC Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 CC Turbo Man
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 CC Sportium Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 CC Sportium Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207 Gti Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Manual
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XS Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XSE Turbo Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XSE Turbo Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 Sportium Turbo Auto
February |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XTE Turbo Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XS 1.6 Diesel Manual
Customer | Sale Date | Car | N/U/D | RDA | Stock No | Del Date | Gross | Warranty | After/M | Finance | Pay | Sale No |  |  |  |  |  | 308 XS 1.6 Diesel Semi Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XSE 2.0 Diesel Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XSE 2.0 Diesel Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XSE 1.6 Diesel Semi Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 Sportium 2.0 Diesel Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XTE 2.0 Diesel Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XSE Touring 1.6 Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XSE Touring Turbo Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 Sportium Touring Turbo Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XS Touring 1.6 Diesel Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XS Touring 2.0 Diesel Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XSE Touring 2.0 Diesel manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 XSE Touring 2.0 Diesel Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 Sportium Touring 2.0 Diesel Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 CC Turbo Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 CC Turbo Auto
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 CC 2.0 Diesel Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 CC XTS Turbo Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308 CC XTS 2.0 Diesel Auto
March |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3008 XSE 1.6 Diesel Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3008 XSE 1.6 Diesel Semi Auto
Customer | Sale Date | Car | N/U/D | RDA | Stock No | Del Date | Gross | Warranty | After/M | Finance | Pay | Sale No |  |  |  |  |  | 3008 XTE 1.6 Diesel Semi Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3008 XSE Turbo Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3008 XTE Turbo Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3008 XSE 2.0 Diesel Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3008 XTE 2.0 Diesel Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 407 ST Diesel Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 407 Executive Diesel Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4007 ST Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4007 ST Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4007 ST 7 Seat Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4007 SV Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RCZ Turbo Auto
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RCZ 2.0 Diesel Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Partner 1.6 Petrol L1 Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Partner 1.6 Petrol L1 3 seat Manual
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Partner 1.6 Diesel L2 Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Partner 1.6 Diesel L2 3 seat Manual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expert 2.0 Diesel SWB
April |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expert 2.0 Diesel LWB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expert 2.0 Diesel LWB PRO
Customer | Sale Date | Car | N/U/D | RDA | Stock No | Del Date | Gross | Warranty | After/M | Finance | Pay | Sale No
Total
May
Customer | Sale Date | Car | N/U/D | RDA | Stock No | Del Date | Gross | Warranty | After/M | Finance | Pay | Sale No
Total
June
Customer | Sale Date | Car | N/U/D | RDA | Stock No | Del Date | Gross | Warranty | After/M | Finance | Pay | Sale No
Total
July
Customer | Sale Date | Car | N/U/D | RDA | Stock No | Del Date | Gross | Warranty | After/M | Finance | Pay | Sale No
Total
August
Customer | Sale Date | Car | N/U/D | RDA | Stock No | Del Date | Gross | Warranty | After/M | Finance | Pay | Sale No
Total
September
Customer | Sale Date | Car | N/U/D | RDA | Stock No | Del Date | Gross | Warranty | After/M | Finance | Pay | Sale No
Total
October
Customer | Sale Date | Car | N/U/D | RDA | Stock No | Del Date | Gross | Warranty | After/M | Finance | Pay | Sale No
Total
November
Customer | Sale Date | Car | N/U/D | RDA | Stock No | Del Date | Gross | Warranty | After/M | Finance | Pay | Sale No
Total
December
Customer | Sale Date | Car | N/U/D | RDA | Stock No | Del Date | Gross | Warranty | After/M | Finance | Pay | Sale No
Total