Spreadsheet: 697825d1601560533-sum-if-s-and-round-up-incorrect-formulae-tally-23
Sheet: sheet1

Vessel : |  |  | KEILA K121 |  |  |  | Total
Date: |  |  | 2020-09-11 00:00:00 |  | Boxes |  | [NAME]
Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg)
 |  |  |  | Boxes | Weight | Cost
 | COD | GH | 1 | 5 | 35 | 180
 | COD | GH | 2 | 2 | 35 | 174
 | COD | GH | 2 | 6.5 | 35 | 172
 | COD | GH | 3 | 9.5 | 35 | 140
 | COD | GH | 3 | 7 | 35 | 130
 | COD | GH | 4 | 11 | 35 | 122
 | COD | GH | 4 | 5 | 35 | 120
 | COD | GH | 5 | 10 | 35 | 90
 | COD | GH | 5 | 7 | 35 | 80
 | HAD | GH | 2 | 1 | 9 | 31.5
 | HAD | GH | 3 | 1 | 23 | 80.5
 | HAD | GH | 4 | 4 | 40 | 136
 | HAD | GH | 5 | 4 | 40 | 112
 | HAD | GH | 6 | 22 | 40 | 100
 | HAD | GH | U | 30 | 40 | 67
 | WHG | GH | 2 | 4 | 40 | 98
 | WHG | GH | 2 | 8 | 40 | 92
 | WHG | WF | 4 | 55 | 40 | 78
 | WHG | WF | 4 | 29 | 40 | 76
 | WHG | WF | 4 | 12 | 40 | 74
 | WHG | WF | 4 | 12 | 40 | 72
 | HKE | GH | 2 | 1 | 20 | 88
 | HKE | GH | 3 | 1 | 35 | 150
 | HKE | GH | 4 | 4 | 35 | 130
 | HKE | GH | 5 | 2 | 35 | 72
 | HKE | GH | 5 | 10 | 35 | 68
 | HKE | GH | 5 | 11 | 35 | 66
 | HKE | GH | 6 | 13 | 35 | 48
 | ANF | GH | 3 | 1 | 13 | 42
 | ANF | GH | 4 | 1 | 26 | 84
 | ANF | GH | 5 | 1 | 24 | 70
 | ANF | GH | 6 | 1.75 | 40 | 110
 | SQU | WF | U | 1.25 | 30 | 165
 | POK | GH | 4 | 2 | 40 | 34
 | LIN | GH | 2 | 2.5 | 40 | 62
 | LEZ | GH | 1 | 1 | 30 | 216
 | LEZ | GH | 2 | 1.5 | 30 | 166
 | LEZ | GH | 3 | 1 | 30 | 132
 | LEZ | GH | 4 | 1 | 19 | 60
 | PLE | GH | 2 | 1 | 40 | 110
Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg)
 |  |  |  | Boxes | Weight | Cost
 | PLE | GH | 3 | 2 | 40 | 104
 | PLE | GH | 3 | 2 | 40 | 92
 | LEM | GH | 3 | 1 | 30 | 144
 | HBT | GH | U | 1 | 7 | 100
 | HBT | GH | U | 1 | 15 | 230
 | JOD | GH | U | 1 | 3 | 10
 | MAC | WF | U | 1.5 | 40 | 78
 | COD | GH | 2 | 1 | 26 | 120
 | COD | GH | 3 | 5 | 35 | 136
 | HAD | GH | 3 | 1.75 | 40 | 160
 | HAD | GH | 4 | 4 | 40 | 102
 | HAD | GH | 5 | 11 | 40 | 84
 | HAD | GH | 6 | 1 | 40 | 60
 | HAD | GH | 6 | 4 | 40 | 50
 | HAD | GH | 6 | 4 | 40 | 45
 | WHG | WF | 4 | 3 | 40 | 65
 | PLE | GH | 2 | 1 | 39 | 76
 | PLE | GH | 2 | 6.75 | 39 | 70
 | PLE | GH | 3 | 10 | 39 | 51
 | PLE | GH | 4 | 16 | 39 | 48
 | LEZ | GH | 2 | 14.25 | 35 | 192
 | LEZ | GH | 3 | 7 | 35 | 140
 | LEZ | GH | 4 | 2.25 | 35 | 114
 | LEZ | GH | U | 7.25 | 35 | 52
 | WIT | GH | U | 1.5 | 40 | 34
 | LEM | GH | 1 | 1 | 18 | 40
 | LEM | GH | 2 | 1 | 40 | 80
 | LEM | GH | 3 | 1 | 29 | 30
 | LIN | GH | 2 | 1 | 25 | 36
 | HKE | GH | 5 | 1 | 35 | 48
 | ANF | GH | 1 | 1 | 25 | 82
 | ANF | GH | 2 | 1 | 50 | 164
 | ANF | GH | 3 | 1 | 45 | 172
 | ANF | GH | 3 | 2 | 45 | 170
 | ANF | GH | 3 | 2 | 45 | 150
 | ANF | GH | 4 | 3 | 45 | 152
 | ANF | GH | 4 | 30.5 | 45 | 145
 | ANF | GH | 5 | 3 | 45 | 130
 | ANF | GH | 5 | 21 | 45 | 127
 | ANF | GH | 5 | 6.25 | 45 | 125
 | ANF | GH | 6 | 18.25 | 45 | 110
 | POL | GH | 2 | 1 | 17 | 72
Merchant |  |  |  |  |  |  | Total (£) | [NAME] | Total (Kg)
 | RJC | GH | 4 | 1.5 | 40 | 40
 | TBT | GH | U | 0 | 9.3 | 130
 | TBT | GH | U | 1 | 31.3 | 475
 | TBT | GH | U | 1 | 17.6 | 275
 | TBT | GH | U | 0 | 4 | 54
 | SQU | WF | U | 1 | 25 | 140
 | SQU | WF | U | 4 | 30 | 170
 | SQU | WF | U | 3 | 30 | 160
 | SQU | WF | U | 5 | 30 | 165
 | SQU | WF | U | 7 | 30 | 155
 | SQU | WF | U | 14 | 30 | 150
 | SQU | WF | U | 5 | 30 | 140
 | SQU | WF | U | 4 | 30 | 135
 | SQU | WF | U | 2.5 | 30 | 75
 | HAD | GH | 3 | 2.25 | 40 | 160
 | HAD | GH | 4 | 3 | 40 | 108
 | HAD | GH | 4 | 11.25 | 40 | 106
 | HAD | GH | 5 | 34 | 40 | 86
 | HAD | GH | 5 | 16.75 | 40 | 85
 | HAD | GH | 5 | 10 | 40 | 80
 | HAD | GH | 5 | 22 | 40 | 77
 | HAD | GH | 6 | 3 | 40 | 70
 | HAD | GH | 6 | 24 | 40 | 68
 | HAD | GH | 6 | 16 | 40 | 64
 | HAD | GH | 6 | 14 | 40 | 59
 | HAD | GH | 6 | 20.25 | 40 | 57
 | WHG | GH | 3 | 4 | 40 | 70
 | WHG | GH | 4 | 9 | 40 | 68
 | LEM | GH | 3 | 2 | 40 | 120
 | LEM | GH | 3 | 1 | 40 | 145
 | BLL | GH | U | 1 | 15.5 | 225
 | LEM | GH | U | 1 | 16 | 40
 | JOD | GH | U | 1 | 9 | 105
 | PLE | GH | 2 | 1 | 18 | 28
 | PLE | GH | 3 | 1.5 | 40 | 60
 | PLE | GH | 4 | 6.5 | 40 | 54
 | RJM | GH | 4 | 4 | 40 | 45
 | POK | GH | U | 1 | 19 | 20