sumproduct using half value of first array

[ajm]

I am trying to work out a formula that will sum hourly rates by 50% of the hours charged. how do i work in the 50% calculation to the array housing the nbr of hours per person? the answer i want is the sum of the 50% column.

	Hours	Charge	1:1 (100%)	50%
	12	20	240	120
	336	34	11,424	5,712
	25	54	1,350	675
	12	18	216	108
	48	12	576	288
	24	100	2,400	1,200
SUMPRODUCT(P63:P68,Q63:Q68)
16,206			16,206	8,103

 

[DanteAmor]

This is what you need?

varios 15jun2023 big numero.xlsm
	P	Q	R	S
62	Hours	Charge
63	12	20
64	336	34
65	25	54
66	12	18
67	48	12
68	24	100
69			1:1 (100%)	50%
70			16,206	8,103
Hoja6

Cell Formulas
Range	Formula
R70	R70	=SUMPRODUCT(P63:P68,Q63:Q68)
S70	S70	=SUMPRODUCT(P63:P68,Q63:Q68/2)

Or this:

varios 15jun2023 big numero.xlsm
	P	Q	R	S
62	Hours	Charge
63	12	20
64	336	34
65	25	54
66	12	18
67	48	12
68	24	100
69			1:1 (100%)	50%
70			16,206	8,103
Hoja6

Cell Formulas
Range	Formula
R70	R70	=SUMPRODUCT(P63:P68,Q63:Q68)
S70	S70	=R70/2

 

[bebo021999]

MAy be:
=SUMPRODUCT(P63:P68,Q63:Q68)*0.5
???