Add sum of products in a row

[lachone]

PAID	CHURCH
	YOUTH SIZES	ADULT SIZES
Name	XS	SM	MED	LRG	XLRG	SM	MED	LRG	1x	2X	3X	4X			# OF SHIRTS	TOTAL DUE
		$13.50	$13.50	$13.50	$13.50	$13.50	$13.50	$13.50	$13.50	$13.50	$15.50	$17.50	$19.50
	Pastor						1	1	1		1				4	#NAME?
	Nykky	1							1	1					3
	Sherle								2						2
	Monica							1	2						3
	Tia								1						1
	Marvella								1		1				2
	Hawkins								1			1	1		3
	Mrs. Margie										1				1
	Ms. Eldora				1					1					2
	Lisa									1					1
	Ma Lynn								1						1
	Gino												1		1
	Gary										1				1
	Shuggie	1		1		1				1		1	1		6
	Jessica						1		2						3
	Chelle									1					1
	Benita									1					1
	Denise							1							1
	Arlene		1						1						2
	Carla										1				1
															0
															0
	Sub-total	2	1	1	1	1	2	3	13	6	5	2	3
															40	#NAME?
		Grand Total Youth	6			Grand Total Adult	34

<tbody>
</tbody>

In Q6 I put in the following formula: =SUM(C6*$C$5)+(D6*$D$5)+(E6*$E$5)+(F6*$F$5)+(G6*$G$5)+(H6*$H$5)+(I6*$I$5)+J(J6*$J$5)+(K6*$K$5)+(L6*$L$5)+(M6*$M$5)+(N6*$N$5) but it does not work. ANY help is appreciated.

 

[AhoyNC]

Try SUMPRODUCT. Copy down rows as needed.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	PAID	CHURCH
2
3			YOUTH SIZES					ADULT SIZES
4	Name		XS	SM	MED	LRG	XLRG	SM	MED	LRG	1x	2X	3X	4X		# OF SHIRTS	TOTAL DUE
5			$13.50	$13.50	$13.50	$13.50	$13.50	$13.50	$13.50	$13.50	$13.50	$15.50	$17.50	$19.50
6		Pastor						1	1	1		1				4	$56.00
7		Nykky	1							1	1					3	$40.50
24		Arlene		1						1						2	$27.00
25		Carla										1				1	$15.50
26																0
27																0
28		Sub-total	2	1	1	1	1	2	3	13	6	5	2	3			$576.00
29
30			Grand Total Youth				6			Grand Total Adult				34		40
Sheet

 

[lachone]

No luck. UGH...

 

[Fluff]

Please do not quote entire posts, as it just messes up the thread.

Are the values in C5:N5 numbers formatted to show the $ sign, or are they text?

 

[AhoyNC]

What does no luck mean, wrong answer, error msg., etc.?
Also, as Fluff has asked are any of the values actually text?

 

[lachone]

"No luck" refers to AhoyNC's suggestion.
Mr Excel - It is formulated to have the $ - My apologies for messing up the post.
Fluff - Everything in the "Q" column and the row of prices is set to currency - the number of shirts on the sheet are "general"

 

[Fluff]

As Ahoy NC asked, what exactly does "No Luck" mean?

 

[popipipo]

[B]=sum(c6*$c$5)+(d6*$d$5)+(e6*$e$5)+(f6*$f$5)+(g6*$g$5)+(h6*$h$5)+(i6*$i$5)+[COLOR=#ff0000]j[/COLOR](j6*$j$5)+(k6*$k$5)+(l6*$l$5)+(m6*$m$5)+(n6*$  n$5)[/B]

Remove the red J and the formula will work.

 

[lachone]

All smiles! Thank you!

 

[Dave Patton]

=SUM(C6*$C$5+D6*$D$5+E6*$E$5+F6*$F$5+G6*$G$5+H6*$H$5+I6*$I$5+J6*$J$5+K6*$K$5+L6*$L$5+M6*$M$5+N6*$N$5)

or
=SUMPRODUCT($C$5:$N$5,C6:N6)

yield the $56