Formula for the day total. i want to multiply the qty sold by price for each item and need the sum of the items sold in a day

[acarwreck]

REGISTER.xlsx
	K	L	M	N	O	P	Q	R
91		PRICE	Date:	1	2	3	4	5
92	APPLE	45	QTY	1	2	4		6
93	GOLD	30	QTY		1		1
94	BRICK	100	QTY	2
95	SAND	150	QTY	4			7	2
96	FERRARI	25	QTY		3			5
97
98		DAY TOTAL
MART SALE

 

[FormR]

Hi, welcome to the forum! Like this maybe? If not, try filling in your expected results manually and explain how you arrive at those expected results.

Book1
	K	L	M	N	O	P	Q	R
91		PRICE	Date:	1	2	3	4	5
92	APPLE	45	QTY	1	2	4		6
93	GOLD	30	QTY		1		1
94	BRICK	100	QTY	2
95	SAND	150	QTY	4			7	2
96	FERRARI	25	QTY		3			5
97
98		DAY TOTAL		845	195	180	1080	695
Sheet1

Cell Formulas
Range	Formula
N98:R98	N98	=SUMPRODUCT($L$92:$L$96,N92:N96)

 

[acarwreck]

Hi, welcome to the forum! Like this maybe? If not, try filling in your expected results manually and explain how you arrive at those expected results.

Book1
	K	L	M	N	O	P	Q	R
91		PRICE	Date:	1	2	3	4	5
92	APPLE	45	QTY	1	2	4		6
93	GOLD	30	QTY		1		1
94	BRICK	100	QTY	2
95	SAND	150	QTY	4			7	2
96	FERRARI	25	QTY		3			5
97
98		DAY TOTAL		845	195	180	1080	695
Sheet1

Cell Formulas
Range	Formula
N98:R98	N98	=SUMPRODUCT($L$92:$L$96,N92:N96)

yes this helped. this is exactly what i wanted thank you so much!