Spreadsheet: 740469d1626353094-not-calculating-correctly-after-certain-line-value-error-sfsales-dec-2020-to-present-july-2021
Sheet: Customer Purchases Overview

Customer | Product | Count of Invoice Number | Sum of Qty | Sum of Price | Sum of Subtotal
AEV | Fish [NAME]g | 1 | 1 | 320 | 320
 | Fish [NAME]g | 1 | 1 | 65 | 65
AEV Total |  | 2 | 2 | 385 | 385
[NAME] IS Natural | Fish [NAME] | 1 | 3 | 995 | 2685
[NAME] IS Natural Total |  | 1 | 3 | 995 | 2685
Anneke Erasmus Mulder | Fish [NAME] | 1 | 1 | 1125 | 1044
Anneke Erasmus Mulder Total |  | 1 | 1 | 1125 | 1044
[NAME] | Fish [NAME]g | 1 | 1 | 320 | 320
[NAME] |  | 1 | 1 | 320 | 320
Aunty [NAME] | Fish [NAME]g | 1 | 1 | 320 | 320
Aunty Rookaya Amla Total |  | 1 | 1 | 320 | 320
Baboo Mama Vaid |  | 1 | 1 | 125 | 125
[NAME] | Fish Collagen 80g | 1 | 1 | 125 | 87.5
[NAME] |  | 1 | 1 | 125 | 87.5
Cassim Osman Sina Health Company | Fish Collagen 20kg | 1 | 1 | 19900 | 19900
 | Fish [NAME] TNT | 1 | 1 | 19900 | 19900
Cassim Osman Sina Health Company Total |  | 2 | 2 | 39800 | 39800
[NAME] Agent | Fish Collagen 80g | 1 | 3 | 125 | 300
[NAME] Agent Total |  | 1 | 3 | 125 | 300
[NAME] | Fish [NAME] | 1 | 1 | 1125 | 1125
Ferozia Haffejee Total |  | 1 | 1 | 1125 | 1125
Hibah Muhammed | Fish Collagen 20kg | 1 | 1 | 19900 | 15200
 | Fish Collagen 80g | 1 | 1 | 125 | 95
Hibah Muhammed Total |  | 2 | 2 | 20025 | 15295
Humza Papa Qurtuba | Fish [NAME] | 1 | 1 | 1125 | 1125
Humza Papa Qurtuba Total |  | 1 | 1 | 1125 | 1125
[NAME] | Fish Collagen 500g | 1 | 1 | 599 | 575
[NAME] |  | 1 | 1 | 599 | 575
Junior MV | Fish [NAME]g | 1 | 1 | 320 | 312
Junior MV Total |  | 1 | 1 | 320 | 312
[NAME] | Fish Collagen 80g | 1 | 1 | 125 | 125
[NAME] Total |  | 1 | 1 | 125 | 125
Khatija Rahimtoola | Fish [NAME] | 1 | 2 | 1125 | 2250
Khatija Rahimtoola Total |  | 1 | 2 | 1125 | 2250
[NAME] | Fish [NAME] | 1 | 1 | 1125 | 995
[NAME] |  | 1 | 1 | 1125 | 995
Ma | Fish [NAME]g | 1 | 3 | 320 | 960
 | Fish [NAME] | 1 | 1 | 995 | 995
Ma Total |  | 2 | 4 | 1315 | 1955
[NAME] | Fish [NAME] | 1 | 1 | 1125 | 1174
Marie Saunders Total |  | 1 | 1 | 1125 | 1174
MEV | Fish [NAME]g | 1 | 1 | 320 | 320
MEV Total |  | 1 | 1 | 320 | 320
Mo Lockat | Fish [NAME]g | 1 | 1 | 320 | 320
Mo Lockat Total |  | 1 | 1 | 320 | 320
[NAME] | Fish Collagen 80g | 1 | 10 | 125 | 1000
[NAME] |  | 1 | 10 | 125 | 1000
Moulana [NAME] | Fish Collagen 500g | 1 | 1 | 599 | 599
Moulana Moosa Olgar Total |  | 1 | 1 | 599 | 599
[NAME] [NAME] | Fish Collagen 80g | 1 | 10 | 125 | 1000
[NAME] Khan Total |  | 1 | 10 | 125 | 1000
Nabewieyah Daniels | Fish [NAME]g | 1 | 1 | 320 | 344
Nabewieyah Daniels Total |  | 1 | 1 | 320 | 344
[NAME] | Fish [NAME] | 1 | 1 | 1125 | 995
Nandlal Govan Total |  | 1 | 1 | 1125 | 995
[NAME] | Fish Collagen 80g | 1 | 1 | 125 | 125
[NAME] |  | 1 | 1 | 125 | 125
[NAME] | Fish [NAME] | 1 | 1 | 1125 | 1199
[NAME] |  | 1 | 1 | 1125 | 1199
Sajida Amla Kazee | Fish [NAME]g | 1 | 3 | 320 | 936
Sajida Amla Kazee Total |  | 1 | 3 | 320 | 936
Storm Hugo | Fish Collagen 80g | 1 | 4 | 125 | 500
Storm Hugo Total |  | 1 | 4 | 125 | 500
[NAME] | Fish [NAME] | 1 | 1 | 1125 | 1125
[NAME] |  | 1 | 1 | 1125 | 1125
Tahseen Ally [NAME] | Fish [NAME] | 1 | 2 | 1125 | 1990
Tahseen Ally Hoosan Total |  | 1 | 2 | 1125 | 1990
ZEV | Fish [NAME] | 1 | 1 | 1125 | 1125
 | Fish [NAME] | 1 | 1 | 995 | 995
ZEV Total |  | 2 | 2 | 2120 | 2120
[NAME] | Fish [NAME]g | 1 | 1 | 320 | 380
Zohra Mall Total |  | 1 | 1 | 320 | 380
Zubair Rawat | Fish [NAME] | 1 | 1 | 995 | 895
Zubair Rawat Total |  | 1 | 1 | 995 | 895
Grand Total |  | 40 | 71 | 81643 | 83845.5