Weighted Average for Non-Contiguous Data

[zafega]

Good Morning,

I am trying to get a weighted average of data that is not contiguous
I am using this formula: =SUMPRODUCT(BL117:BL134,BJ117:BJ134)/SUM(BJ117:BJ134)
The data I need to be included in the formula is just the "ut" one, excluding the "m" ones.
Columns are BJ, BK, BL and rows from 117 to 134.
Any help is very much appreciated.

Best regards,

Federico

[TABLE="width: 447"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]75[/TD]
[TD]ut[/TD]
[TD]8,205[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]646[/TD]
[TD]m[/TD]
[TD]4,367[/TD]
[/TR]
[TR]
[TD]174[/TD]
[TD]m[/TD]
[TD]5,590[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]ut[/TD]
[TD]7,900[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]ut[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]ut[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]ut[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]ut[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]ut[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]ut[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]ut[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]ut[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]ut[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]ut[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]177[/TD]
[TD]ut[/TD]
[TD]85,000[/TD]
[/TR]
</tbody>[/TABLE]

 

[JoeMo]

Excel Workbook
	BJ	BK	BL	BM	BN
117	75	ut	8,205		57071.13309
118
119	646	m	4,367
120	174	m	5,590
121	26	ut	7,900
122
123	0	ut	0
124	0	ut	0
125	0	ut	0
126
127	0	ut	0
128	0	ut	0
129	0	ut	0
130	0	ut	0
131	0	ut	0
132	0	ut	0
133	0	ut	0
134	177	ut	85,000
Sheet4

 

[zafega]

Thanks @JoeMo for the solution.
I can see the differences between the formulas.
Thanks again