Multiply a string of cells per the criteria

[Grexx]

HI, I hope I formulated the topic correctly. What I want to do is to multiply Rooms by ADR for each date and sum them together to get total revenue for all days in a given segment (for example in row 5 and the result will be in cell S5). I thought of going with SUMPRODUCT but cannot figure out how. Can you please help? Thank you.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1			7-Aug	7-Aug	8-Aug	8-Aug	9-Aug	9-Aug	10-Aug	10-Aug	11-Aug	11-Aug	12-Aug	12-Aug	13-Aug	13-Aug	Totals
2			Monday	Monday	Tuesday	Tuesday	Wednesday	Wednesday	Thursday	Thursday	Friday	Friday	Saturday	Saturday	Sunday	Sunday
3			Rooms	ADR	Rooms	ADR	Rooms	ADR	Rooms	ADR	Rooms	ADR	Rooms	ADR	Rooms	ADR	Rooms	%	Revenue
4	RACK	var	-1	$12.78	0	$13.76	6	$44.68	3	$39.83	3	$81.55	3	-$18.26	1	-$28.16	15	3%	$(118.12)
5		D1	4	$117.86	4	$117.86	7	$134.06	7	$144.43	5	$175.84	5	$147.84	4	$141.91	36	6.96%	$ -
6		D2	5	$105.08	4	$104.10	1	$89.38	4	$104.60	2	$94.29	2	$166.10	3	$170.07	21	5.87%	$ 118.12
7	Internet	var	21	$19.77	18	$14.87	20	$9.47	18	$16.75	13	$11.34	9	$14.09	9	$18.03	108	21%	$ 10.74
8		D1	34	$106.71	32	$110.47	33	$109.77	37	$111.28	51	$135.27	53	$138.06	30	$126.01	270	52.22%	$ 121.85
9		D2	13	$86.94	14	$95.60	13	$100.30	19	$94.53	38	$123.93	44	$123.97	21	$107.98	162	45.25%	$ 111.11
10	Other Discounts	var	5	-$18.05	5	-$16.43	5	$22.48	8	$32.87	0	$38.53	-5	$26.76	0	$12.85	18	3%	$ 16.40
11		D1	25	$128.27	17	$140.33	17	$150.72	21	$150.07	31	$160.05	34	$166.58	23	$132.97	168	32.50%	$ 148.75
12		D2	20	$146.32	12	$156.76	12	$128.24	13	$117.20	31	$121.52	39	$139.82	23	$120.12	150	41.90%	$ 132.35
13	Rack, Internet, Discounts Totals	var	25	-$4.61	23	-$0.59	31	$12.19	29	$23.55	16	$24.39	7	$16.90	10	$12.05	141	27%	$ 11.72
14		D1	63	$115.97	53	$120.61	57	$124.97	65	$127.38	87	$146.43	92	$149.13	57	$129.93	474	91.68%	$ 132.84
15		D2	38	$120.58	30	$121.20	26	$112.78	36	$103.84	71	$122.04	85	$132.23	47	$117.88	333	93.02%	$ 121.12

<tbody>
</tbody>

<tbody>
</tbody>

 

[jarjarbingie]

HI, I hope I formulated the topic correctly. What I want to do is to multiply Rooms by ADR for each date and sum them together to get total revenue for all days in a given segment (for example in row 5 and the result will be in cell S5). I thought of going with SUMPRODUCT but cannot figure out how. Can you please help? Thank you.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1			7-Aug	7-Aug	8-Aug	8-Aug	9-Aug	9-Aug	10-Aug	10-Aug	11-Aug	11-Aug	12-Aug	12-Aug	13-Aug	13-Aug	Totals
2			Monday	Monday	Tuesday	Tuesday	Wednesday	Wednesday	Thursday	Thursday	Friday	Friday	Saturday	Saturday	Sunday	Sunday
3			Rooms	ADR	Rooms	ADR	Rooms	ADR	Rooms	ADR	Rooms	ADR	Rooms	ADR	Rooms	ADR	Rooms	%	Revenue
4	RACK	var	-1	$12.78	0	$13.76	6	$44.68	3	$39.83	3	$81.55	3	-$18.26	1	-$28.16	15	3%	$(118.12)
5		D1	4	$117.86	4	$117.86	7	$134.06	7	$144.43	5	$175.84	5	$147.84	4	$141.91	36	6.96%	$ -
6		D2	5	$105.08	4	$104.10	1	$89.38	4	$104.60	2	$94.29	2	$166.10	3	$170.07	21	5.87%	$ 118.12
7	Internet	var	21	$19.77	18	$14.87	20	$9.47	18	$16.75	13	$11.34	9	$14.09	9	$18.03	108	21%	$ 10.74
8		D1	34	$106.71	32	$110.47	33	$109.77	37	$111.28	51	$135.27	53	$138.06	30	$126.01	270	52.22%	$ 121.85
9		D2	13	$86.94	14	$95.60	13	$100.30	19	$94.53	38	$123.93	44	$123.97	21	$107.98	162	45.25%	$ 111.11
10	Other Discounts	var	5	-$18.05	5	-$16.43	5	$22.48	8	$32.87	0	$38.53	-5	$26.76	0	$12.85	18	3%	$ 16.40
11		D1	25	$128.27	17	$140.33	17	$150.72	21	$150.07	31	$160.05	34	$166.58	23	$132.97	168	32.50%	$ 148.75
12		D2	20	$146.32	12	$156.76	12	$128.24	13	$117.20	31	$121.52	39	$139.82	23	$120.12	150	41.90%	$ 132.35
13	Rack, Internet, Discounts Totals	var	25	-$4.61	23	-$0.59	31	$12.19	29	$23.55	16	$24.39	7	$16.90	10	$12.05	141	27%	$ 11.72
14		D1	63	$115.97	53	$120.61	57	$124.97	65	$127.38	87	$146.43	92	$149.13	57	$129.93	474	91.68%	$ 132.84
15		D2	38	$120.58	30	$121.20	26	$112.78	36	$103.84	71	$122.04	85	$132.23	47	$117.88	333	93.02%	$ 121.12

<tbody>
</tbody>

<tbody>
</tbody>

S4=SUM(IF($C$3:$O$3="Rooms",$C4:$O4*$D4:$P4,0)) press CTRL+SHIFT+ENTER