Multiply & Sum Columns

[radley1]

Hi All
I need to be able to create a formula to find out the number of units that are ordered on each day of the week.
When a customer inputs a number into the day of the week column (MONDAY/TUESDAY) they are inputting the number of cases they want to order. I need this to then multiply by the units per case to let me know how many units are being ordered on each day.
I then need to be able to sum the total across the rows for each column. So in below example, I need to be able to find out that in Monday there are 360 units in total & Tuesday 540 units.

Units Per Case	MONDAY	TUESDAY
90	1
90		2
90		2
90
90	2
90
70
45
45	2
45
45		2
45
45		2
35
TOTAL	360	540

 

[Georgiboy]

Maybe:

Book1
	A	B	C
1	Units Per Case	MONDAY	TUESDAY
2	90	1
3	90		2
4	90		2
5	90
6	90	2
7	90
8	70
9
10	45
11	45	2
12	45
13	45		2
14	45
15	45		2
16	35
17	TOTAL	360	540
Sheet1

Cell Formulas
Range	Formula
B17:C17	B17	=BYCOL(B2:C16,LAMBDA(x,SUM(x*A2:A16)))
Dynamic array formulas.

 

[Fluff]

Another option

Fluff.xlsm
	A	B	C
1	Units Per Case	MONDAY	TUESDAY
2	90	1
3	90		2
4	90		2
5	90
6	90	2
7	90
8	70
9
10	45
11	45	2
12	45
13	45		2
14	45
15	45		2
16	35
17	TOTAL	360	540
Master

Cell Formulas
Range	Formula
B17:C17	B17	=SUMPRODUCT($A$2:$A$16,B2:B16)