Forum Discussion
My formula stop working in the middle row position
Hello there, In simple description, I just make an cigarettes inventory checklist for my company. I have 1 excel file containing 2 sheets inside. The first sheet is called "Data Barang", and t...
Change the formula in the Stock Akhir column to
=[@[Stock Awal]] - SUMIF('Log Pemakaian'!$C:$C, [@Kode], 'Log Pemakaian'!$F:$F)
or even better,
=[@[Stock Awal]] - SUMIF(Table3[Kode], [@Kode], Table3[Jumlah])