daily incremental data

[mwvirk]

I am receiving a commission daily how can I add it to a sheet to add in existing data?
like on 30 Nov my total commission was 100
on 1st Dec I got another 10 so the total will be 110
now on 2nd Dec, I got another 20 so the total is 130
I also want to differentiate that how much is total gain today
I have a total of 200 clients and each one generates different commissions but it's not confirmed that all 200 clients generate commissions every day. sometimes only 50 out of 200 generate commission and sometimes 100

 

[mwvirk]

OK. i think i should try vlookup

can someone please help me in this #Value error:

MMK Clients Data.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	F5114	32	49	29		110174	121,380	9,803.1172	1,470.1075	15.00%		#VALUE!
2	FQ89	66600	4,039.00	563		110207	27,025	810.7500	98.0952	12.10%		#VALUE!
3	HK130	33	2	0		8144	93,407	8,536.0421	655.3687	7.68%		#VALUE!
4	HK143	20000	717	92		9299	200,817	11,948.6807	1,784.9115	14.94%		#VALUE!
5	HK186	500	41	4		C1206	10	8.3930	1.3629	16.24%		#VALUE!
6	NR188	30000	2,317.00	250		F5114	281,991	51,355.3406	30,955.9897	60.28%	29.00	30,984.9897
7	NR302	1500	375	40		FQ89	1,429,380	82,638.2897	12,168.2240	14.72%	563.00	12,731.2240
Commission

Cell Formulas
Range	Formula
J1:J7	J1	=IF(H1>0,I1/H1,0)
K1:K7	K1	=IF(ISNA(VLOOKUP(F1,A:D,4,FALSE)),"",VLOOKUP(F1,A:D,4,FALSE))
L1:L7	L1	=I1+K1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J1:J60	Other Type	DataBar		NO

 

[etaf]

NOT really following on what info
oh you posted
change the I1+K1 to
=SUM(I1,K1)

as the formula is creating a ""
which is giving the Value error

that answers the value error

But i'm not following the original question & in context of the sample you produced
explain further using your example as context