Selective weighted average

[UndwaterExcelWeaver]

In the table below I need to be able to calculate the weighted average of salt results using only the recipes that have a salt result present. While I have total recipe lbs for all recipes, I do not have salt results for all recipes. So, I need to be able to exclude those recipes that do not have salt results. Can someone help me with a formula to accomplish this? Thanks

Nancy Plant Mass Balance 1023.xlsm
	E	F	G	H	I	J	K
144				Lbs	Moisture	Fat	Salt
145	Nancy Water Packed Big Size			4,830	60.28	16.95	0.88
146	Nancy Marinade			9,720	61.37	16.85	1.02
147	Nancy Water Packed <2oz			16,272	61.00	16.90	0.82
148	Nancy Thermoform			118,538	60.64	17.57	1.06
149	Nancy Water Packed <2oz NT II			663	61.00	16.90
150	Nancy Water Packed Big Size NT II			0	0.00	0.00
151	Nancy Thermoform NT II			31,910	60.30	17.28	0.76
152	Nancy Marinade NT II			0	0.00	0.00
153	Burrata			0	0.00	0.00
154	FS Weighted av (065)			181,933	60.65	17.40	0.98
19

 

[offthelip]

that is exactly the equation I posted in post#6 just with different rows numbers!! so you could mark it as the answer