Weighted avg horizontal

[WOOKID]

I am looking for the weighted avg.- the answer would be in column "AL"; I could take (AB*AF)+(AC*AG)+(AD*AH)+(AE*AI) =AL etc....

Is there a more effective way to calculate where I do not have to type out each combo?

Note: columns will line up 1:1.

THANK YOU! -

 

[Candyman8019]

try something like: =sumproduct(AB4:AE4,AF4:AI4)/sum(AF4:AI4)

 

[awoohaw]

does this work:

Mr Excel Questions 3.xlsm
	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL
1	Current Rate				Current Rate
2	A	B	C	D	A	B	C	D
3	3545	3651	4476	5055	0.2	0.3	0.1	0.3			3768.4
Sheet5

Cell Formulas
Range	Formula
AL3	AL3	=SUMPRODUCT(AB3:AE3,AF3:AI3)