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 the second sheet is "Log Pemakaian".
The first sheet "Data Barang" in C column range contains the Item Code value, next to it range from D column contain Item Name, then E column contain initial stock of items, lastly F contain final stock of items
The second sheet "Log Pemakaian" in C column contains item code value formula automaticaly taken Data Validation from first sheet.
Formula should be working like this:
First sheet "Data Barang" on F column is where my formula located, if the column F from "Log Pemakaian" contain value number look for the item code from cell C3 then reduce it from initial stock of items at first sheet "Data Barang" which contain initial stock of items in E columns within the same name of item code respectively.
=IF(ISNUMBER(@'Log Pemakaian'!$F:$F), E3 - SUMIF('Log Pemakaian'!$C:$C, C3, 'Log Pemakaian'!$F:$F), E3)
The issue is:
My formula stopped working when it reach Row 28 "Kansas" item name, no mater what I type for usage and quantity from second sheet its just keep displaying initial stock at final stock column.
See the excel file from here.
1. Insert cigarettes name in "Log Pemakaian" sheet, example I choose "Kansas"(where formula happen error) cigarettes and the item code beside should be automatically pop.
2. Insert any amount of quantity.
3. Look at Data Barang sheet, its not change.
4. Starting from here till bottom formula not displaying final stock.
I really need your help to inspect and see what is wrong with my sheet formula, i'm so frustated even ChatGPT can't help me.
Also my friend around here doesn't have knowledge for excell formulas.
I'll be very thankful if anyone can help me 🙂
