Created attachment 183199 [details] G7: =SUM(G4:G6) sould be 158.5， but it reports 89.5. Apparantely, misses G6 value. It's a very serious mistake. 2S or 2P with Alumium Form Cup Cost analysis 項次 品名 材質 規格 單價(元/PCS) 用量(電芯2pcs) 材料組成 備註 1 電芯鋁板 AL5052(t=1mm) 252*150*14mm 34.5 2 69 連續模模具28萬(MOQ1000K) 2 電芯絕緣紙 NOMEX 雙背 A298(0.18t，含膠) 0.23t(含膠)*235mm*145mm 26.5 1 26.5 MOQ：500KPCS 3 鋁板絕緣紙 NOMEX 雙背 A298(0.18t，含膠) 0.23t(含膠)*251mm*148mm 31.5 2 63 MOQ：1000KPCS Total Cost( NTD): 89.5 Sum Function calculation will miss the last one.
Most likely G6 contains text that looks like a number but is not of type numeric. See this FAQ https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data