Spreadsheet: 269376d1381147453-look-up-of-countif-help-samplesalessheet
Sheet: Input

Date Sold 3-7 October 2013
 | Item Number | eBay Price | QTY Sold | Sold Price True
 | 329500 | 5
 | 329501 | 5
 | 329508 | 5
 | 329545 | 5
 | 329544 | 5
 | 329516 | 5
 | 329526 | 6
 | 329525 | 6
 | 329529 | 6
 | 329528 | 6
 | 329533 | 6
 | 329532 | 6
 | 329537 | 6
 | 329536 | 6
 | 329535 | 6
 | 329534 | 6
 | 332921 | 40.45500000000001
 | 342212 | 40.5
 | 329192 | 40.5
 | 337780 | 40.5
 | 337791 | 36
 | 321372 | 40.5
 | 333034 | 25.29
 | 327163 | 29.7
 | 325600 | 20
 | 333041 | 20
 | 332614 | 27.96
 | 334572 | 27.96
 | 334603 | 39.96000000000001
 | 230099 | 39.96000000000001
 | 224215 | 39.96000000000001
 | 342232 | 40
 | 225937 | 35.96
 | 332005 | 35.96
 | 334441 | 30.36
 | 334413 | 30.36
 | 214534 | 43.96000000000001
 | 334311 | 28
 | 229908 | 43.16
 | 334633 | 39.96000000000001
 | 225944 | 39.96000000000001
 | 325199 | 21
 | 325192 | 21
 | 199456 | 15
 | 222938 | 15
 | 225654 | 15
 | 225693 | 15
 | 221345 | 15
 | 221351 | 15
 | 199463 | 15
 | 330276 | 28.8
 | 226602 | 22.4
 | 219433 | 15.4
 | 335761 | 15.4
 | 230300 | 21
 | 230301 | 21
 | 333468 | 16.1
 | 335795 | 11.893
 | 330280 | 21
 | 335764 | 16.194
 | 184015 | 0.5
 | 400444 | 9.600000000000001
 | 400305 | 12
 | 310274 | 4
 | 206256 | 1.996
 | 305659 | 1.996
 | 190255 | 0.8199999999999997
 | 329514 | 2
 | 329513 | 2
 | 329519 | 2
 | 329520 | 2
 | 329582 | 1.2
 | 310561 | 1.2
 | 329587 | 1.5
 | 329580 | 0.7499999999999998
 | 329498 | 0.9999999999999998
 | 329499 | 0.9999999999999998
 | 308666 | 5.6
 | 212074 | 5.6
 | 308709 | 5
 | 325860 | 3.995
 | 163316 | 4
 | 228249 | 20
 | 228248 | 20
 | 333466 | 8.399999999999999
 | 333477 | 2
 | 339941 | 8
 | 339940 | 8
 | 339939 | 8
 | 334068 | 8.399999999999999
 | 334067 | 8.399999999999999
 | 334066 | 8.399999999999999
 | 334069 | 8.399999999999999
 | 333473 | 8.399999999999999
 | 333472 | 8.399999999999999
 | 333471 | 8.399999999999999
 | 186255 | 1.196
 | 213376 | 11.7
 | 222932 | 12
 | 329572 | 4
 | 329571 | 4
 | 329570 | 4
 | 329569 | 4
 | 329568 | 4
 | 329564 | 4
 | 329563 | 4
 | 329562 | 4
 | 329561 | 4
 | 329585 | 4
 | 329560 | 4
 | 329559 | 4
 | 329579 | 4
 | 329578 | 4
 | 329574 | 4
 | 329552 | 4
 | 329551 | 4
 | 329550 | 4
 | 329549 | 4
 | 329548 | 4
 | 329547 | 4
 | 183720 | 3
 | 183719 | 3
 | 187502 | 2.396
 | 329509 | 3
 | 183728 | 2.999999999999999
 | 183727 | 2.999999999999999
 | 329505 | 2
 | 325442 | 0.7499999999999998
 | 325441 | 0.7499999999999998
 | 329518 | 0.9999999999999998
 | 335842 | 24
 | 191029 | 13.86
 | 226260 | 19
 | 325430 | 10
 | 326666 | 10
 | 311257 | 10
 | 214850 | 31.455
 | 214852 | 31.96
 | 199499 | 20
 | 199498 | 21
 | 215835 | 10
 | 225726 | 10
 | 182866 | 0.5979999999999999
 | 142653 | 0.3989999999999999
 | 334065 | 10.4
 | 334062 | 10.2
 | 334063 | 7.8
 | 334064 | 7.8
 | 305817 | 5.600000000000001
 | 323013 | 5.25
 | 229998 | 2.25
 | 333478 | 2.25
 | 211966 | 10.5
 | 212712 | 10.5
 | 221481 | 10.5
 | 170163 | 0.4999999999999999
 | 203369 | 0.4999999999999999
 | 214028 | 5
 | 214283 | 5
 | 172507 | 6
 | 171149 | 6
 | 114376 | 1.5
 | 333215 | 36
 | 214422 | 26.4
 | 333251 | 32
 | 333276 | 32
 | 324308 | 28
 | 117473 | 26.6
 | 335836 | 26.6
 | 323450 | 9
 | 225787 | 15
 | 225800 | 12
 | 324352 | 9.1
 | 221682 | 10
 | 330279 | 56
 | 321651 | 40
 | 333480 | 2
 | 333479 | 2
 | 190254 | 11.28
 | 222797 | 20
 | 187464 | 8
 | 323461 | 3.999999999999999
 | 325858 | 0.3899999999999999
 | 211988 | 5.369999999999999
 | 336205 | 4
 | 228341 | 27
 | 326561 | 15
 | 325423 | 5.97
 | 310552 | 5
 | 329359 | 6
 | 329422 | 6
 | 330021 | 8.399999999999999
 | 330099 | 8.399999999999999
 | 315326 | 5
 | 197209 | 2
 | 325781 | 4.199999999999999
 | 190708 | 1.995
 | 333467 | 7.5
 | 193613 | 31.96
 | 224688 | 9
 | 199837 | 10
 | 314917 | 3
 | 314912 | 3
 | 324396 | 4.995
 | 196503 | 3.55
 | 306354 | 4
 | 310875 | 3.2
 | 214692 | 3.64
 | 325351 | 3
 | 323435 | 3
 | 325377 | 3
 | 306133 | 3
 | 325384 | 3
 | 323481 | 3
 | 305227 | 3
 | 323497 | 3
 | 325402 | 3
 | 323466 | 3
 | 209776 | 3
 | 223986 | 0.9999999999999998
 | 325774 | 0.9999999999999998
 | 326265 | 2
 | 218344 | 1.4
 | 326360 | 2.999999999999999
 | 326351 | 2.999999999999999
 | 326462 | 2.999999999999999
 | 329095 | 2.999999999999999
 | 329109 | 2.999999999999999
 | 329091 | 2.999999999999999
 | 329323 | 2.999999999999999
 | 218242 | 1.82
 | 323517 | 2.999999999999999
 | 323493 | 2.999999999999999
 | 323489 | 2.999999999999999
 | 300248 | 2.999999999999999
 | 323477 | 2.999999999999999
 | 222387 | 2.999999999999999
 | 320154 | 2
 | 218302 | 2
 | 333145 | 2
 | 333133 | 2
 | 333152 | 2
 | 333137 | 2
 | 333140 | 2
 | 307954 | 0.9999999999999998
 | 218363 | 0.9999999999999998
 | 218309 | 1.4
 | 218367 | 1.4
 | 315753 | 0.9999999999999998
 | 219275 | 4
 | 229542 | 20
 | 403501 | 12.6
 | 196173 | 20
 | 308210 | 20
 | 221471 | 18.48
 | 229527 | 32
 | 325035 | 32
 | 324184 | 32
 | 326621 | 16
 | 310754 | 10.5
 | 311335 | 20.37
 | 221601 | 21
 | 333289 | 21
 | 222809 | 18
 | 326626 | 15
 | 315853 | 10
 | 218599 | 6
 | 218387 | 6
 | 218804 | 5.640000000000001