Question: how to calculate weighted average foreign exchange rate?
Answer: The weighted average is now calculated as SUMPRODUCT(range with Dollar amounts, range with Export rates)/sum of Dollar amounts.