Formula

Question

I have a spread sheet that product weights are constantly added to every day. It is a running tally.

I am trying to find a way to keep track of the total completed quantity, the quantity completed today, and the starting quantity.

I can calculate the total quantity no problem, but the others I am having issues with.

Below are the formulas I am working with. Attached is a screen shot of what I am looking to figure out

Order Qty	UOM	Start QTY	Today QTY	Completed QTY	# of Days	Done (Initials)
1000	kgs	cant figure out	cant figure out	=IF(G8="","",SUM(G8:G60))	=IF(A11="","",COUNT(UNIQUE(A8:A42)))
Date	PIC	Starting Net	Today Whole Units	Net per Unit	Today Net Completed	Total Net Completed
Jan-31-2024	X	0.00	5	5.00	=IF(D8="","",IF(E8="","",SUM(D8*E8)))	=IF(F8="","",F8)
Feb-01-2024	X	=IF($B9="x",(SUM(F8)),"")	5	75.00	=IF(D9="","",IF(E9="","",SUM(D9*E9)))	=IF(F9="","",SUM($F$8:F9))
Jan-24-2024	x	=IF($B9="x",(SUM(F8)),"")			=IF(D10="","",IF(E10="","",SUM(D10*E10)))	=IF(F10="","",SUM($F$8:F10))
Feb-06-2024		=IF($B11="x",(SUM($F$8:F10)),"")			=IF(D11="","",IF(E11="","",SUM(D11*E11)))	=IF(F10="","",SUM($F$8:F11))

Answer 1

Here is your modified file, I formatted the data as table so the formulas grows as the table grows automatically.

https://www.dropbox.com/scl/fi/lzpah80dbxy2g3t1r1vjz/959e178e-913c-4ed0-8883-43987002c595.xlsx?rlkey=bh3a7xu75wh7lvpu33idtv4lt&dl=1

Andreas.

Answer 2

Hi,

When i click on the Download button, i am asked for log-in credentials.

Answer 3

Please find the link below.

https://www.dropbox.com/scl/fi/b0hm2auywe4jycux7keca/Template1.xlsx?rlkey=8l1m0rig98zw4xs5vdlv37ooy&dl=0

Answer 4

We need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

Andreas.